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 you'll have to do this in desktop. You cannot do this online. The changes haven't happened in your report, they have occurred in the source (SQL, or excel file or whatever it is). Someone made changes to the source tables and did not inform you. You will have to edit your data transform to reflect those changes properly in your report. PowerBI is expecting the data to come in a certain way and your source is sending the data a different way now. That's where the disconnect is.
And no problem! This happens all the time when the analyst doesn't have direct control over the data source.
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.
- pborah
yvonneT 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!