Theres supposedly a new fix to the Facebook Insights API end points:
Does this fixes up the actual problem of the missing posts?
That's great news! - I checking with the developer to make sure they are aware this is finally available and can update our connector. Once I have confirmation that this does fix it and the change is underway for our connector, I will update the known issue article for this.
Thanks for letting us know!
The fix was deployed today to our connector - please lease refresh your Sheet acquire the latest version of the connector.
Also note that the new endpoint requires stronger permissions to allow for "managing your pages" so that it can function. If you get the following error, please log out of the Facebook Insights connector and back in to accept the new permissions level.
Fetching Facebook posts requires new permissions ("manage Pages"). Please log out from the Facebook Insights data source and then log in again, granting the new permissions.