Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data source error: Report structure hash stored in salesforceDataSet

I have a number of Salesforce reports as data sources for a Power BI dataset and it has been running successfully on a scheduled refresh for 6+ months

 

Recently the refresh started to fail and I'm not sure how I go about determining the source (e.g. a specific report?) of the issue from the error message.

 

The error message is:

 

Data source error: Report structure hash stored in salesforceDataSet: 4BA3632CA28D2776012205BFBCE9E544 doesn't match report structure received from Salesforce: 944629AEEAC0692910AC521B7769C2E9. CPEX[|{"ErrorCode":"UnknownError","ExceptionCulprit":0,"IsPermanent":false,"Message":"Report structure hash stored in salesforceDataSet: 4BA3632CA28D2776012205BFBCE9E544 doesn't match report structure received from Salesforce: 944629AEEAC0692910AC521B7769C2E9"}|]. The exception was raised by the IDbCommand interface.



Cluster URI: WABI-WEST-US-redirect.analysis.windows.net

Activity ID: a36c15d7-2159-42a0-b71d-b51cc281f111
Request ID: 09d33486-df86-6c4a-2984-b5df8d16f91b
Time: 2019-11-13 01:41:37Z
Show On demand 11/13/2019, 12:18:44 PM 11/13/2019, 12:26:57 PM Failed There was an error when processing the data in the dataset.

 

Thanks!

Need Help

5 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    hi Anonymous 

    You may try to download the pbix file and refresh it in power bi desktop see if there is something wrong in power bi desktop and check the error in power bi desktop and edit queries.

     

    Regards,

    Lin

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks v-lili6-msft for your response.

       

      This might be a stupid question, but how do I download a .pbix file from the dataset (and associated Report and Dashboard) that I've built in the Power BI service on the web? I didn't think this was possible?

       

      Actually, now that I think more on this, it may not help me much as one of the limitations of PBI Desktop is that it ignores formulas in the Salesforce report (the PBI service doesn't ignore them) and the formulas are what most of my reports rely on.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Just reiterating that I don't see an option to download this as a .pbix given it was created in the PBI web service, not from PBI Desktop and published (I do see it with other datasets that I built and published from PBI Desktop).

         

        I do have to say that right now, frustratingly, Microsoft has actually made it impossible for me to use Power BI as a visualzation tool for my org's Salesforce data between:

        * PBI Desktop can only return 10,000 reports (my org has over 20,000)

        * PBI Desktop doesn't import or handle formulas or groupings in SFDC reports

        * PBI service has moved to 'app' model and the Salesforce Reports service has simply disappeared

  • ReportMaster's avatar
    ReportMaster
    Post Partisan
    2 years ago

    Hi Anonymous, 

    I know this reply is very late lol, but were you able to find a solution? I've used the Salesforce connector but I had some issues updating my data too. Maybe you can try to test your connection with a 3rd party connector. I've tried windsor.ai, supermetrics (which doesn't have PBI as a destination, so you first have to export to Google Sheets and then export to PBI) 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's avatar
    metrica
    Post Prodigy
    1 month ago

    Hello,

     

    This does not look like a Salesforce credentials issue. The error points to a Salesforce report structure mismatch.

    Power BI stored one report structure, but during refresh Salesforce returned a different one. I would check whether the report changed recently, especially fields, formulas, grouping, renamed columns, removed fields, report type, or layout metadata.

     

    If possible, recreate the failing report connection or use a stable copy of the Salesforce report for Power BI.

    The native Salesforce Reports connector can be fragile here and also has the frustrating 2,000-row limit.

     

    Another option is Power BI Connector for Salesforce by Metrica Software: https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577

     

    It lets you create Salesforce data sources, select objects and fields, apply filters, preview the output, and connect Power BI to a prepared source.

     

    This will not repair an already broken native Salesforce Reports dataset, but it gives you another path to rebuild the connection with a controlled schema.

     

    Docs and support:
    https://metricasoftware.com/docs/salesforce/
    https://metricasoftware.com/docs/salesforce/contact-support/

     

    Cheers,
    Metrica Team