Forum Discussion
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:...
Hi jfenico
I recently encountered the same issue saying that one column doesn’t exist, but the dataset refreshes fine on Power BI desktop.
It turns out that the issue was to do with my Power BI desktop had auto-detect of relationship on, so there was a relationship auto created that was not intended and I wasn't aware of it. Then, one of the columns in that relationship was removed later one, this is the column that was causing issue in the refresh. After deleting the relationship and republishing the model, it refreshed fine.
Hope this helps.
Cheers