How to add additional Salesforce Reports to an existing dataset based on Salesforce Reports

[AnthonyB]

I have successfully created a dataset from multiple Salesforce Reports, and then created a report and Dashboard from the dataset.

I now have some new Salesforce reports that I would like to add to this dataset to include in the existing report and dashboard.

I can't see any way to add additional Salesforce reports to a dataset? Am I missing something or is it simply not possible?

[v-yuezhe-msft]

@AnthonyB,

Do you directly connect to Salesforce report in Power BI Service or in Power BI Desktop? In Power BI Desktop, you are able to connect to multiple data sources in same PBIX file, just click "Get Data->More->Salesforce report" to add additional tables you want.

Regards,
Lydia

[AnthonyB]

I'm forced to use Power BI service (web) as I can't use Power BI Desktop due to the other issue I posted (only returning first 10,000 rows/reports, I have almost 20,000 reports, can't rename my reports, etc.)

[v-yuezhe-msft · Accepted solution]

@AnthonyB,

In Power BI Service, it is  not possible to add additional salesforce reports to an exsiting dataset, I am afraid that you would need to create the dataset again.

Regards,
Lydia

[AnthonyB]

Thanks for confirming that Lydia.

Disappointing that it requires creating a complete new dataset and there is no capability to add a new Salesforce report to an existing dataset. Hope that is something that can be considered as a feature in a future release as it really renders Power BI as a very limited solution for me to use with Salesforce.