Forum Discussion
No error Refresh in Power Bi Desktop, but have DataSource error in Power Bi Service
So, I was finally able to solve this problem.
The issue was with my data source credentials. Because my report used different data sources, it expected that each source would have the same credential as the other.
To solve the issue, I went to the semantic models of my report and changed each credential to be the same as the other. For example, I used the OAuth2 authentication method and privacy level was set to Organizational for each of the data sources.This solved the problem for me. I hope it does for you as well.
Best of luck.
PS: If this solves the issue, please accept it as a solution to help others as well
In my case, I had 2 column headers that changed name (source is excel) - I had to remove lines above and then apply headers. So whenever the header text changed, I got this error.
Had to update the step with the error with the new/updated column names (which is a bit of a pain if the title has a line feeder in it).