Getting millions of rows from Salesforce Objects

[albran]

I'm trying to use the Salesforce Objects connector to see all of my sales by product in Power BI Desktop.  I have narrowed the very wide orders table down to just a few columns but I need over 30 million rows and it seems like that won't work, i.e. it never finishes importing the data when I click Apply in the Power Query editor.  Will it just not work and I do have to do the aggregations in a Salesforce report or in the Advanced Query Editor?  I don't need to display the details but I do need to let the end user select a product and see total sales.

[v-piga-msft]

Hi @albran ,

Firstly, you could refer to this similar thread which may be helpful.

In addition, for your scenario, you may could create the query parameter for the product so that your user could select the parameter to show the specific data.

More details about query parameter, please refer to this blogs below.

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

Best  Regards,

Cherry

[albran]

Thanks but the forum post is unrelated so not useful.  And using parameters doesn't help either since there are millions of rows for one of my products.  It seems like I either need to put all the data into a warehouse and query it from there, or do an import in Power BI if I can make the dataset small enough.