Power BI integration with Salesforce Big objects

[minaxi]

Hi,

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.

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.

Please let me know if there is any way to get the Big Objects from Salesforce in Power BI for the online reporting?.

Thanks

Minaxi

[KattyNamor]

What about some kind of alternative solutions?
For example, replicate all your SF data to SQL Server (there are several good tools for that, Skyvia for ex.) and then use the standard PowerBI connector.

[drussellgbc]

Has anyone discovered a method for pulling Big Object data into Power BI? These objects still do not appear in the object list via the built-in connector.

[v-yuezhe-msft]

@minaxi,

Please check if you can connect to the big objects using the Salesforce objects connector in Power BI Desktop. You are able to create reports in Power BI Desktop and then publish reports to Power BI Service.

Regards,
Lydia

[minaxi]

Hello Lydia, No those big objects are not appearing in the options when i am using salesforce object connector.

What else option we can opt in to use salesforce big objects ?

[v-yuezhe-msft]

@minaxi,

Is there any possibility that you create ODBC data source for the Big objects? You can connect to ODBC data source in Power BI Desktop.

Regards,
Lydia

[minaxi]

Lydia

Not sure if this will work. I am first trying out to install ODBC driver. Due to lengthly protocols here in my organization, it takes long  to install any driver/software. I am taking help from below link.

https://www.simba.com/products/Salesforce/doc/ODBC_QuickstartGuide/content/quick_start/windows/sa/co...

Will come back to you with the results.

Regards

Minaxi

[v-yuezhe-msft]

@minaxi,

How  is the issue going?

Regards,
Lydia

[minaxi]

Due to some reasons, we couldnot get the ODBC drivers. And we are still in the phase of POC.

I got somewhere in the salesforce documentation that we can query Big Objects using a subset of the SOQL (Salesforce Objects Query Language) via a REST API.

Then using Poser BI web connector REST API query details can be abstracted.

I am new to Power BI, can you suggest me how this can be accomplished?