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.
Cross posted from Integrations-
I am trying to complete the FB tutorial (using microsoftbi posts) and repeatedly get the error =
Details: Facebook : (#100)-The 'limit' parameter should not exceed 100
I have installed the most current version of PowerBI desktop.
How can I get past this problem?
Thanks much!!!
Solved! Go to Solution.
I think I found the root cause: The April update to the PowerBI desktop client. Checked in with a collegue who still had the March version and the connector worked for him. Upgraded his client and he got the same errors.
Will checkout the May release.
After you select facebook from Get Data, on the ' "Me", user name or Objetct ID ' dialog, insert microsoftbi or whatever page you are trying to connect to. On ' "Connection" ' select --None--. Then go to the Advanced Editor and add the following to the query: /posts?limit=100
let
Source = Facebook.Graph("https://graph.facebook.com/v2.8/microsoftbi/posts?limit=100")
in
Source
Hello,
Am still getting this error using the below Power BI Desktop version even after trying the workround of selecting --None-- and then appying the limit in Advanced Editor:
Version: 2.46.4732.581 64-bit (May 2017)
Can anyone suggest what am I doing wrong?
Regards
Nirav
Looks like it is case-sensitive.
Just change 'Posts' to 'posts' in the URL:
Source = Facebook.Graph("https://graph.facebook.com/v2.2/microsoftbi/posts?limit=100")
Works for me.
try this one- remove the version part from uri and give limit value less than 100.
I think I found the root cause: The April update to the PowerBI desktop client. Checked in with a collegue who still had the March version and the connector worked for him. Upgraded his client and he got the same errors.
Will checkout the May release.
Probably nobody in this forum knows those tutorials. Can you provide a link?
I get the same error at step 4 of task 1.
It must be some issue inside the connector that we are not able to see.
As a workaround you can create a blank query and start with the code step from the end result of the tutorial:
= Facebook.Graph("https://graph.facebook.com/microsoftbi/posts")
My suggestion would be to provide feedback on the tutorial page stating that the information on that page is not helpful and formulate the issue.
Am afraid that workaround won't look good in a demo. Thanks for the idea...I have provided feedback on the tutorial page. Sure hope someone sees it before my demo!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |