OData Feed SharePoint List Data Refresh Issue: Too Many Lookup Columns
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.
Old report wont load with PBI RS january 2019
Hello, I have an issue with the PBI RS january 2019 update. One of my reports wont load anymore. This report has been created with PBI desktop august 2018 and was working fine when published on PBI RS august 2018. Now I have this error when I try to visualise it on PBI RS january 2019: Then I openned and saved it with PBI desktop january 2019 but I cant publish it anymore on PBI RS january 2019. This report is critical for my company and I dont know what to do :/ I tried to publish it on PBI cloud and it worked just fine. Thank you for your help
