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

Question

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:

Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

The 'Target_Group__c' column does not exist in the rowset.

The column in question is from Salesforce but is not used in any visulization. If I open the PBIX file and manually refresh, everything works fine. Any thoughts?

_sfrost · Answer

jfenico&nbsp;Did you ever use this column in your report? if so, may be there are pinned tiles on dashboard those refer to this column? We might run into issues like this in such scenarios too.

jfenico · Answer

_sfrostNope - I only use a few columns in the report from this table and this is not one of them.

v-deddai1-msft · Answer

Hi&nbsp;jfenico&nbsp;,
&nbsp;
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.
&nbsp;
And if you have use&nbsp;“Pivot columns” transformation in the Power query&nbsp;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.
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;
Best Regards,
Dedmon Dai

jfenico · Answer

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 · Answer

Hi&nbsp;jfenico&nbsp;,
&nbsp;
Would you please check if anyone has modified&nbsp; the data structure like remove columns in the data source. You need to republish it to power bi service.
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;
Best Regards,
Dedmon Dai
&nbsp;
&nbsp;

Forum Discussion

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

Related content

Refresh Failure

Report Refresh Failures

Scheduled Refresh Failure

Refreshing Failure

New, consistent refresh failures