cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AnthonyB Frequent Visitor
Frequent Visitor

Salesforce Reports and Power BI Desktop - only returns first 10,000 reports in alphabetical order

I have a number of Salesforce reports I want to use as data sources in Power BI.

As an organization, we have close to 20,000 reports sitting in our Salesforce instance.

I am using Power BI Desktop Version: 2.64.5285.741 64-bit (November 2018).

I understand the Salesforce API limit of 10,000 rows.

 

In Power BI Desktop, when I use Salesforce Reports connector to get data, it returns the first 10,000 reports in alphabetical order. Unfortunately, we have close to 20,000 reports and the reports I need to use are not in this first 10,000. I do not want to rename them all with a prefix to 'force' them to the top of the alpha order Smiley Happy

 

In Power BI web, when I use the Salesforce Reports service content pack, it returns the list of reports with the reports I most recently accessed at the top of the list, which is great as I can easily select all of the reports I want to use as data sources.

 

I do not see any way in PBI Desktop to have it return the list of Salesforce reports based on my last access.

 

Is this correct? Or have I missed some way to achieve this?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Salesforce Reports and Power BI Desktop - only returns first 10,000 reports in alphabetical orde

@AnthonyB,

For the above feature request, I would recommend you submit it in Power BI ideas forum.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Moderator v-yuezhe-msft
Moderator

Re: Salesforce Reports and Power BI Desktop - only returns first 10,000 reports in alphabetical orde

@AnthonyB,

As your post, salesforce report connector in Power BI Desktop only returns first 10000 reporrs. I am afraid that you would need to rename the required reports to make them appear in top order.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
AnthonyB Frequent Visitor
Frequent Visitor

Re: Salesforce Reports and Power BI Desktop - only returns first 10,000 reports in alphabetical orde

Thanks Lydia!

 

Would it be possible for the Salesforce Connector in Power BI Desktop to have the same option as the PBI Web content pack where it can import 10,000 based on most recently accessed?

 

This would:

1. Solve my problem

2. Provide consistency between PBI Web and Desktop

 

I appreciate that this is a feature request and not something that could be solved immediately.

 

It is very frustrating as renaming all of the Salesforce reports I use isn't really an option (number of reports and report naming standards we use), and I really need to use PBI Desktop for further data massaging that I can't do directly in PBI Web.

Moderator v-yuezhe-msft
Moderator

Re: Salesforce Reports and Power BI Desktop - only returns first 10,000 reports in alphabetical orde

@AnthonyB,

For the above feature request, I would recommend you submit it in Power BI ideas forum.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.