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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
LucasLiachi
New Member

facebook

Hi! i try conect facebook, every datas. so this erros insist: "Facebook: (#100) The 'limit' parameter should not exceed 100" please, help me.

i try this solution https://community.powerbi.com/t5/Community-Knowledge-Base/Facebook-100-The-limit-parameter-should-no... but dont come all datas

but not solution

and haved more people with this problem:
https://community.powerbi.com/t5/Desktop/Error-on-FB-tutorial-Details-Facebook-100-The-limit-paramet...

And more
https://community.powerbi.com/t5/Desktop/Facebook-Data-limit-results/m-p/7445#M1051

1 ACCEPTED SOLUTION
v-ljerr-msft
Employee
Employee

Hi @LucasLiachi,

 

Based on my test with the latest version of Power BI Desktop, instead of adding "/Posts?limit=100", adding "/posts?limit=100" to the url in the Advanced Editor works for me. Could you go to check if it work in your scenario? Smiley Happy

= Facebook.Graph("https://graph.facebook.com/v2.8/microsoftbi/posts?limit=100")

facebook.PNG

 

Regards

View solution in original post

4 REPLIES 4
v-ljerr-msft
Employee
Employee

Hi @LucasLiachi,

 

Based on my test with the latest version of Power BI Desktop, instead of adding "/Posts?limit=100", adding "/posts?limit=100" to the url in the Advanced Editor works for me. Could you go to check if it work in your scenario? Smiley Happy

= Facebook.Graph("https://graph.facebook.com/v2.8/microsoftbi/posts?limit=100")

facebook.PNG

 

Regards

tringuyenminh92
Memorable Member
Memorable Member

Hi @LucasLiachi,

 

As my observation, just use none in Connections with limit 100, it will load all data of page as my checking in June. 

tringuyenminh92
Memorable Member
Memorable Member

Hi @LucasLiachi,

 

As my observation, just use none in Connections, it will load all data of page as my checking in June. 

Hi @LucasLiachi

As a workaround you may try to import your facebook data into windsor.ai account and access it with Power BI.

 

windsor.ai facebook.png

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.