Forum Discussion

Ancar's avatar
Ancar
Frequent Visitor
9 years ago
Solved

facebook data - reach, engagement etc.

Hi all, I am working on analysing a bunch of Facebook pages, and relying on downloading each one of these 14 pages data to excel, copy+paste:ing and importing to Power BI is really not an option any...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    Ancar

     

    As mentioned in that API document:

     

    • A user access token with read_insights permission can retrieve metrics for all pages and domains owned by this user.
    • A page access token with read_insights permission can retrieve all metrics for that Page.

    Otherwise, you can only get publicly available metrics (currently page_fans_country or page_storytellers_by_country).

     

    Regards,

Ancar's avatar
Ancar
Frequent Visitor
9 years ago

Perfect, thanks v-sihou-msft

 

I will need to dig into how to apply a User Access Token to my Power BI Query - do you know if that's possible?

I looked around trying to find a way to add my Access token (app?) created in developer.facebook.com into power Bi so it realizes i gave permission - but I don't see anywhere where that is possible. Is there some code in the Power BI Advanced Editor? 

 

Looking around all i seem to find is to write C# or to connect to Azure in some way... to do it, but I am not a coder :) nor a great database hacker: https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-walkthrough-push-data-get-token/

and https://www.codeproject.com/Tips/1042542/Connecting-to-Power-BI-REST-API-from-a-Service-i-e

 

If you have found a good way to give my Power BI (which uses my regular credentials for Facebook today) permission that would be more than appreciated :)

 

Thanks for all your time and help!

Kind regards,

Andreas

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Ancar

 

I think the "User Access Token with read permission" mentioned in the facebook API doc should mean the permission associated to your factbook account, not the Power BI account.

 

It means those information related to pages is only available for those facebook users, like Admintrator of public pages.

 

Regards,