Forum Discussion
Advocate IISalesforce and Power BI
Hi all,
I would like to use Salesforce to create live report in Power BI Service. I already started with 3 reports but before going any further I would like to have some advice/insights on one topics.
I saw that there is a limitation of 5 data sets imported. However, with the limitation of 2,000 rows I need to imports way more than that. My questions here are :
-> We can select multiple report from Salesforce in the same time when we import data in PBI service. If we select 4 reports in the same time, they are all going to be in the same data set. So I see one data set, but to refresh it will have to connect to 4 reports. In this context, does that count for 1 data set or 4 ?
-> Other solution would be to also create reports in PBI Desktop, does the limitation of data sets also concern PBI Desktop ? Or can I import unlimited reports in PBI Desktop because here the refresh is manual ?
The answers to those questions will be critical in my decision on whether I can move to to Power Bi to build report from Salesforce or staying in an Excel format.
If you know other limitations or avatages to use Salesforce with Power I will be happy to read them !!!
Thanks a lot,
AROTH
5 Replies
twalsh0625Advocate I
To get around these limitations. I used a PBI desktop file, you can connect directly to the SF objects, including inheretence of relationships. This gets you around the 2000 record limit, and allows you to build data relationships with data outside of your SF platform. It also allows report building, metric definition and custom columns without having to offer a sacrificial lamb to your SF dev/admin team!
Be careful with your filters and column selection in the query though, as it can be a BEAST to refresh.
ArothThank you both for your feedbacks.
I think that the best way will be to use PBI Desktop and refresh manually in desktop, then load online. But if it's to hard to refresh I will even go through an excel file. It won't use salesforce's connectivty but I'll avoid a lot of restrictions ...
v-jiascu-msftMicrosoft Employee
Hi AROTH,
1. The 5 datasets limit means the restriction of datasets of Salesforce. According to the definition of dataset, I'm afraid 4 reports could be 4 datasets.
Please refer to: Salesforce Dataset: https://help.salesforce.com/articleView.
Limitation: powerbi-content-pack-salesforce/#system-requirements.
2. Power BI doesn't have any limitation of Salesforce. The limits are on the control of Salesforce. You can test it in the Desktop. This post is very helpful: salesforce-connectivity-2000-lines-restriction/. And the reply in this post: remove-2000-row-limit-for-salesforce-power-queries.
Best Regards!
Dale
ReportGuruPost Patron
Hi Aroth were you able to find a solution? As a workaraound, maybe you can try to test your connection with a 3rd party connector, which connects directly to SF objects API and therefore, will let you go through the 2k rows limitation. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:
After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:
There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.
- metrica
Post Prodigy
Hi Aroth,
The most flexible approach is to build your model from Salesforce objects in Power BI Desktop rather than splitting the data across multiple Salesforce reports.
Power BI Connector for Salesforce lets you select the required objects and fields and apply source-side filters without the native Reports connector's 2,000-row limit.
AppExchange and 30-day free trial:
https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577Docs and support:
https://metricasoftware.com/docs/salesforce/
https://metricasoftware.com/docs/salesforce/contact-support/Cheers,
Metrica Team
