Forum Discussion
There was an error when processing the data in the dataset.
Well after hours of trying to figure out what the issue was all I had to do was log in to powerbi desktop and refresh the dataset then went into powerbi online and refreshed and it was successful so i turned back on the refresh schedule.
Solution SageyvonneT that's great to know that a simple refresh resolved your issue, in which case I'm thinking the refresh simply updated your columns automatically.
For future's sake however, for a very similar error message (column doesn't exist in rowset), sometimes the solution is more complicated if you have calculated columns at the data transform stage that depends on a preexisting column coming in from your source. In that case a refresh will fail and you might have to rectify the calculated columns first.
Refreshes also fail if suddenly in your data model, a table on one side of a 1-to-many relationship has duplicate keys. The error usually happens at source i.e. a human entering duplicates in a form. In SQL it might not matter because the table might not be related to another table. But in Power BI if it's part of a relationship to make your report work, the duplicate keys will fail the refresh.
In my experience these two are the most common causes for refreshes failing in service. The error message details provide decent clues.
Please give me kudo if I was able to help you with the solution, I'd appreciate it! All the best!
I don't know exactly because everything was the same before and after, no column changes. I am glad that the refresh resolved the issue though. I do appreciate your prompt responses and help! Thank you so much!