Forum Discussion

VENU's avatar
VENU
New Member
10 years ago
Solved

Using Power BI fetches only one friend list using Graph API

Hi All,

 

I am using Power Bi Desktop (latest version, v2.7). By using Power BI, i connected to Facebook DSource, with credentials using Username(me), and coneection type "Friends". 

 

Here i can able to fetch only one friends list, can you please let me know how to i fetch the all friends lists,

 

Thanks in Advance!

 

 

 


  • VENU wrote:

    Step1 : Using Power Bi Desktop, i had connected to Facebook (Datasource).

     

    Step2: here i am passing objectId ("me") and Connection Type ("Friends")

     

    Step3: I had sign in with my Facebook Uname and pwd, here using third party connection (power BI) i have connected to facebook.

     

    Step 4: my facebook account has 200+ friendslists, but here i am able to generate/fetch one one friend record.

     

    Please help me how can i generate all my friendslist using power BI Desktop tool.

     

     

    Thanks in Advance!

     

     


     

    Not an existing option but your can select custom. According to the Facebook APIs, the path should be "friendlists".

     

     

4 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee

    VENU

     

    Will you share some background on "one friend list" and "one friend lists", I don't familiar with facebook.

     

    I see the connection type "Friends", what does it import? And how the imported is different from your expection?

    • VENU's avatar
      VENU
      New Member

      Step1 : Using Power Bi Desktop, i had connected to Facebook (Datasource).

       

      Step2: here i am passing objectId ("me") and Connection Type ("Friends")

       

      Step3: I had sign in with my Facebook Uname and pwd, here using third party connection (power BI) i have connected to facebook.

       

      Step 4: my facebook account has 200+ friendslists, but here i am able to generate/fetch one one friend record.

       

      Please help me how can i generate all my friendslist using power BI Desktop tool.

       

       

      Thanks in Advance!

       

       

      • Eric_Zhang's avatar
        Eric_Zhang
        Microsoft Employee

        VENU wrote:

        Step1 : Using Power Bi Desktop, i had connected to Facebook (Datasource).

         

        Step2: here i am passing objectId ("me") and Connection Type ("Friends")

         

        Step3: I had sign in with my Facebook Uname and pwd, here using third party connection (power BI) i have connected to facebook.

         

        Step 4: my facebook account has 200+ friendslists, but here i am able to generate/fetch one one friend record.

         

        Please help me how can i generate all my friendslist using power BI Desktop tool.

         

         

        Thanks in Advance!

         

         


         

        Not an existing option but your can select custom. According to the Facebook APIs, the path should be "friendlists".