According to my knowledge it is not possible to integrate power bi with custom salesforce objects using soql.
Power bi integration with salesforce.
You may also evaluate their general user satisfaction.
When prompted enter your salesforce credentials.
A single source of truth that holds insights from every corner of your organization.
Microsoft power bi 97 vs.
They often use power bi to visualize salesforce data and bring in additional data sources but that means switching platforms often.
Salesforce analytics cloud 99.
A power bi or power bi pro subscription that contains the report to embed.
An azure active directory azure ad instance.
Select allow and let power bi access your basic salesforce information and data.
Select analytics for salesforce and select get.
Using salesforce apis to connect salesforce to power bi.
The power bi embedded and the power bi service are separate offerings.
It s provides a great deal of flexibility and the types.
In the services box select get.
Select sign in to start the sign in flow.
Stitch easily connects to your data wherever it lives and automatically copies it to a central data warehouse.
For instance here you can match microsoft power bi s overall score of 9 1 against salesforce analytics cloud s score of 8 8.
In your scenario since you don t want to connect to salesforce report content pack which includes custom objects and fields in power bi service you can create your own reports using power bi desktop.
Using power bi s in built connector.
We got big objects in salesforce application and now our customer want us to built power bi reports using these salesforce big objects instead of custom objects.
Prior to power bi i would have had to consult with a bi professional to develop a dashboard.
This walkthrough addresses that and shows you how to embed a power bi report in a visualforce page inside salesforce allowing you to view all your data and reports in a single application.
I have seen we can use the salesforce custom objects online but there is no such option to integrate big objects directly with power bi.
There are three main prerequisites for embedding a report into salesforce.
Don t wate time extracting data from salesforce and sending it to power bi manually.
There are multiple methods that can be used to connect salesforce to power bi.
In power bi select get data at the bottom of the nav pane.
Read more about the salesforce integration with power bi.
Using power bi s in built connector.