Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

Reply
VENU
New Member

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!

 

 

 

1 ACCEPTED SOLUTION
Eric_Zhang
Microsoft Employee
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".

 

Capture.PNG

 

View solution in original post

4 REPLIES 4
Eric_Zhang
Microsoft Employee
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?

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
Microsoft Employee
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".

 

Capture.PNG

 

i have followed the same but still getting empty table

 

 

 

 ss.PNG 

 

 

 

 

 

 

 

 

 

 

 

 

 

agfb.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors