Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Salesforce refresh from PowerBI.com fails

I am getting a refresh error in Powerbi.com when I try to refresh Salesforce Opportunity data.   Something went wrong There was an error when processing the data in the dataset. Please try again ...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous ,

 

Please delete the dataset and republish the report to service to refresh it again.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Ok, I deleted the dataset, republished, ran refresh and got the same error.

     

    Something went wrong
    There was an error when processing the data in the dataset.
    Please try again later or contact support. If you contact support, please provide these details.
    Data source error: The 'Opportunity_Age__c' column does not exist in the rowset. Table: Opportunity.
    Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
    Activity ID: cdd91c17-eccf-4e56-9422-37d8c3a25624
    Request ID: 39a5add1-074f-deb1-eb29-57b059189c4a
    Time: 2019-05-23 07:00:29Z

     

    I tried it twice and got the same results.

     

    This is just a bit frustrating.  I see others having issue like this, but thier error messages are different, in that, they seem to be pointing to secruity.  This error points out a specific column.  

     

    The column gets added when I add the pull the data from SF.  

     

    I have tried removing the column in Query editor, but I still get the same error.