Forum Discussion

jfenico's avatar
jfenico
Helper III
5 years ago

Failure on refresh - Transient Issue, column does not exist.

Hi all, I am getting a failure on refresh a couple of times a week on my report. The report, which includes data from multiple sources, one of them being Salesforce, is giving me the following error:...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi jfenico ,

 

Did you modify the data structure in the data source? If so, you need to re-publish the pbix file to the Powe BI service again.

 

And if you have use “Pivot columns” transformation in the Power query the value of one of the columns in your data source has been transformed as the column names in your dataset. Therefore, once the value of the pivoted column in your data source changed, the column names will mismatch with the value in your data source, then the error occurs.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

jfenico's avatar
jfenico
Helper III
5 years ago

Hi Dedmon,

Just so I understand correctly, what do you mean by modifying the data structure? I did not use any Pivot Column transformation in the data source.

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    Hi jfenico ,

     

    Would you please check if anyone has modified  the data structure like remove columns in the data source. You need to republish it to power bi service.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai