Forum Discussion

JulienF's avatar
JulienF
Frequent Visitor
9 years ago
Solved

Is connection between Facebook graph API and POWER BI over?

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 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

11 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      JulienF
      Frequent Visitor
      9 years ago

      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 ,:robothappy: 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's avatar
        Anonymous
        Not applicable
        9 years ago

        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