Is connection between Facebook graph API and POWER BI over?

[JulienF]

Hello Data lovers! 

Since this morning I am not able anymore to make connection between Power Bi and Facebook graph api...

I have checked everything ( token, use custom query, ...) and nothing works! That strange beacause I don't recieve email anymore from facebook... I mean when I connected my page account into power Bi I always recieved a mail to say that my user facebook account was connected to Power Bi. Is it Power BI? Or 2.10 graph api ? ( 2.5 was still working yesterday in Power BI...) 

I am a bit in the mud because I work for clients and It was very usefull. Now I am back in root mode by quering the Graph api-->then export json --> to excel --> Power Bi ... It works but sometimes Json to excel data export are not accurate and also source of mistakes and it takes me like a all day compare to couples of hours with a bridge between Power Bi and Facebook graph API! 

Any tips or help? 

Thx! 

Julien 

[EugeneLebedev]

Here is a ready-made code solution that extracts data from Facebook ads into Power BI: https://vidi-corp.com/facebook-ads-connector-to-power-bi-looker/

[Anonymous]

@JulienF,

What error message do you get when connecting to Facebook in Power BI Desktop?  I get the following error message during the connection process.


To solve this issue, open a new blank query in Power BI Desktop and paste the following code in Advanced Editor.

let
    Source = Facebook.Graph("https://graph.facebook.com/v2.10/pagename/posts?limit=100")
in
    Source

And I don’t get email notification saying that my Facebook account was connected to Power BI even though the connection is successful.

Regards,

[JulienF]

@Anonymous Thx! 

I don't have any error message but if I paste the code you gave me in the advanced editor I am not able to fetch any data. Power Bi just copy  the code below the advanced editor window with extra # and " and nothing happen. Anyway @DataChant answered me yesterday by mp and I wrote Fx=facebook.graph... in de query editor without any let in source in the advanced editor and it works , a bit strange but it works (again). I don't really understand because before I used to use the method you gave me and everythings were working fine. 

Thx for your help! 

Julien 

[Anonymous]

@JulienF,

Do you use the latest version of Power BI Desktop(2.49.4831.521)? Would you please post a screenshot about your scenario? And what is the result when you fetch data from Microsoft BI page using the following code?

let
    Source = Facebook.Graph("https://graph.facebook.com/v2.10/microsoftbi/posts?limit=100")
in
    Source

Regards,
Lydia

[JulienF]

Yes I have the lastest version of power BI! 

So here is the response I got using your query 

Then if I only use this one it works

To have all the insights I only have to change api version to 2.3 or 2.6 

Best,

Julien 

[jasperism]

Hi, may i ask how do you change the facebook api ver like you mentioned?

[JulienF]

Hello!

Sorry for the delay! I just changed it in the query as "https://graph.facebook.com/v2.9/... to https://graph.facebook.com/v2.8/..."

Enjoy!

[jasperism]

Hi, I am Jasper. I was wondering how do you change the facebook api ver?

[Anonymous · Accepted solution]

@JulienF,

For your first screenshot, you should paste the code to the Advanced Editor rather than the current Query Editor window. Once you paste the code to Advanced Editor, you will get right data as shown in your second screenshot.


Besides, yes, we need to change api version when getting insights data.


Regards,
Lydia

[JulienF]

Ooooops my bad!!!

But it was working before the update? no? Okay I was maybe too tired yesterday 😛 

Thx for you help

P.S. Do you have any idea how can I fetch data about audience insights form pages  I manage? 

Facebook doc is weird and I don't understand the query they give on their website... You can contact me in mp 😉 

[Anonymous]

@JulienF,

I would recommend you post the question about how to use Facebook API in Facebook community, more experts will assit you  there and you can get better answer.

Regards,
Lydia