Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good afternoon,
I have a custom report in SalesForce that I run weekly and at the end of the month to publish data from one of our teams. I have successfully connected to this report through the SalesForce object selection during data import. I'm now stuck.
How do I extract the data from the object? I was reading that I might have to re-build the report in PowerBI to accept the data from the object. If I have to do that, where do I go to begin that process. I appreciate any help anyone can provide.
Cheers
If you're looking to extract data from a Salesforce custom report into PowerBI, you might indeed need to recreate aspects of the report within PowerBI. However, an alternative approach is to use Skyvia. With Skyvia's integration capabilities, you can directly import data from Salesforce objects to PowerBI. This process involves connecting to your Salesforce account through Skyvia, selecting the desired objects or reports, and then mapping this data for use in PowerBI. It simplifies the data extraction process, allowing you to focus more on data analysis and visualization in PowerBI.
There are two options when connecting to Salesforece; objects and reports.
Objects are the tables that you make reports out of (in Salesforce) and reports are those ones already made.
If you want to access what you've built in Salesforce, use reports.
If you want to build it in Power BI, use objects.
There is a row limitation to Reports I believe. Can't find the documentation.
Thanks @Aron_Moore
I definitely want to avoid the limitation and have connected to the Objects. In Power BI, where do I find the objects imported from SalesForce so I can build that same report in PowerBI? Additionally after I build the report in PowerBI will the data be connected from SFDC to PowerBI or do I have to do additional steps beyond that?
Thank you for your help.
If you connect to the objects, then you'll need to build the report 'from scratch' in Power BI.
Connect to objects and you should get a list of tables.
Then you'll need to bring in all relevant tables to your report and merge, append, and/or join to get the desired results.
For example, I built an opportunity report. So I brought in Opportunity, opportunity product, product, etc. It helps to know the relationship of the objects in Salesforce.
Once it's all built you're connected. You just hit refresh and you'll get the newest data. There are other things you can do like publishing to the service, creating apps, etc.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
98 | |
76 | |
66 | |
59 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |