Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am using PBI Desktop to create a dashboard and publish it to the server. As data source, I am using OData REST service to query the data in the form of https://<SERVER_NAME/_api/web/lists(guid'<LIST_GUID>')/items?$select=Id,Title with additional columns for a total of 20. In PBI Desktop, it loads as expected and gets refreshed without a problem.
When I upload to PBI Server, the OData Source Feed refers to the root data source https://<SERVER_NAME/_api/web/lists(guid'<LIST_GUID>')/items which gives back a 500 error, saying that "the number of lookup columns it contains exceeds the lookup columns threshold enforced". That is true for the entire list but that is not what I am instructing Power BI to do.
Is there any way to refresh the prefiltered data source instead of the entire list?
Thanks.
No one has ever encountered this?
Did you checked this ?
Proud to be a Super User!
I have, but it doesn't really provide useful information apart from the suggestion to increase the list view lookup column threshold, which is not really a best practice.