Forum Discussion

minaxi's avatar
minaxi
Frequent Visitor
8 years ago

Power BI integration with Salesforce Big objects

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

 

 

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      minaxi
      Frequent Visitor
      8 years ago

      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 ?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        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

  • drussellgbc's avatar
    drussellgbc
    Frequent Visitor
    8 years ago

    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.

  • KattyNamor's avatar
    KattyNamor
    New Member
    7 years ago

    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.

  • metrica's avatar
    metrica
    Post Prodigy
    24 days ago

    Hi minaxi,

     

    Salesforce Big Objects may not appear in the native Power BI connector. Salesforce recommends Bulk API or Batch Apex for extracting custom Big Object data, since Async SOQL has been retired.

     

    You may also contact the Power BI Connector for Salesforce team to assess compatibility with your Big Object and index structure: https://metricasoftware.com/docs/salesforce/contact-support/

     

    Cheers,
    Metrica Team