Update (Sep 9th): The root cause for this issue is outside of the Power Query connector code and will not require any update of Power BI Desktop or a modification of logic in any report file. Microsoft intiated a verification process with Facebook, ince this will be done, all the reports will work again. There is no ETA at this stage. To reproduce the problem follow the official Microsoft article here.
Yesterday night (Sep 6th) Power BI Facebook connector started to return errors when used to import public facebook pages. If you are using my Facebook Pages – Basic Analysis template app from AppSource, or have any of my Power BI facebook reports, you will have this error when refreshing your report on public Facebook pages (when you are not their adminstrator):
DataSource.Error: Facebook: (#10) To use ‘Page Public Content Access’, your use of this endpoint must be reviewed and approved by Facebook.
The error will also occur if you use the Facebook connector to import data from Facebook public pages, a technique that I have published in my book and on the blog.
Here is an example of the M code that will return the error:
I am sorry for the inconvenience. This may be a result of a bug by Facebook or due to a policy change by the Facebook platform. It can be resolved once Microsoft team go through an app review and get an approval for the Power BI Facebook app on the Facebook developer platform to get access to public pages. I have opened a ticket with Microsoft and notified the product team and they have started working on this issue.
Please stay tuned.