I am a new user for Power BI. I want to connect data from Salesforce reports, but in the list I get I only find a limited number of them. The report I want to find is below 2000 rows and not stored in a private reports folder (and I get other reports stored in the same public folder as that one).
I get a message of "Search results are limited to already expanded items", what does that mean?
I have the same issue using Power Query.
Can anybody help me finding the solution?
Based on Miguel’s response in this idea, the 2000 row limit is from Salesforce Report API but not from Power BI.
As a workaround for the above issue, you can use Salesforce Object connector in Power BI Desktop to pull all the rows from individual tables and recreate reports you’d like. The Salesforce Object connector doesn’t have the 2000 row limit.
Many thanks, @v-yuezhe-msft
The report I want to find is below 2000 rows, and I don´t even see it the Power BI search results. Is there any kind of limitations on how many reports are delivered (it only shows 10000 reports)? Which is the criteria used if that´s the case?
The workaround I used was to take another old report that appeared in the results and modify it to match the data I wanted to see, buut I would like to know why the other one (being exactly the same) does not appear in the results.
The reason I don´t use Objects is because not all the fields are available, so I need to use Reports in order to pull all the needed data.
Thanks for your help!
Based on your description, you see that a report doesn't return in the list when connecting to SalesForce reports from Power BI Desktop. According to this article, SalesForce report Rest API has the limitation that a list of up to 200 recently viewed reports can be returned, I suspect that this limitation leads to your issue.
I would also recommend you post the question in salesforce forum to get dedicated support about SalesForce report Rest API .
Hi @v-yuezhe-msft, thanks a lot for your support. I checked the article you linked, but none of the limitation is the cause. The report was for sure in the 200 recently viewed records. The workaround I used was to change one of the reports I could see to match it to the one I couldn´t, so at least I got to see the data in Power BI.
I will also check on the Salesforce.com forum.
Rename your report by adding "!!!!" in in front of naming string: "My_Report" -> "!!!!My_Report"
Looks simple, but it just works, solved the same issue for me.
I had the same issue. There appears to be another limit in the number of reports that can be seen - in my case it stopped counting at 10 000.
In the case this is a limitation originating from Salesforce I really wish that they would scrap it, and also remove the 2000 row limitation for importaíng data from a report. The in-app treporting interface inside Salesforce is not very good so any serious analysis needs to be handled in Excel or PowerBI or similar tools.
Find out who's part of the program this season, and welcome the new Super Users.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Learn about the exciting things that happened in July.
All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.
Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.