search

mbilling / PBIConnectors

The Microsoft Power BI custom connector support-project
MIT License
71 stars 33 forks source link

Facebookads connector #29

Open vaalonv opened 3 years ago

vaalonv commented 3 years ago

There are some issues now with the fcb connector, it won't get data.

vaalonv commented 3 years ago

The error from template power bi in scitylana.com.

first Expression.Error: The name 'FacebookAds.Ads' wasn't recognized. Make sure it's spelled correctly.

second Expression.Error: The field 'name' of the record wasn't found. Details: has_error=TRUE error_value=[Record] error_reason=DataSource.Error error_message=Web.Contents failed to get contents from 'https://graph.facebook.com/v6.0/me/adaccounts?access_token=EAAJlUhVTtKsBAFKosAWW0XISZAb2JSJaBy1RN4DZAadChVALvyuBmkWIQjnEVRVZCk9KB2SSOORejEYPXE1jtvOae4iNBtpW70pS28iS3HHySSFDuO42geQ1XOTEUofaE5usz2bpozOa5GehGCMyexkvQZBIpkAfMWfnLDAEzkOOkKyQi9xh&fields=id%2Cname&limit=1' (400): Bad Request

imermetal commented 3 years ago

there is a new version of the facebook API, I just made the update of the FacebookPages.pq file:

Change this: scopes = { "read_insights", "pages_manage_ads", "pages_manage_metadata", "pages_read_engagement", "pages_read_user_content", "pages_manage_posts", "pages_manage_engagement" };

;)