Forum Discussion
Changing SQL Query in Source results in mismatch error
So i created a Power BI report using an SQL Server Query. This query had a certain number of columns. Inorder to do some clean up work, i updated my source sql query. This query had few columns than ...
Hi Anonymous ,
Yes i visited this thread previously. The issue discussed in that thread doesnt have to do with changing the query. In my case, I only have one step (source) and still i am getting the mismatch error. Any how i solved the problem by creating a new source using the new query, then manually updating the table name in every measure and re mapping the relationships to the new table.
I hope microsoft comes up with a solution that gives the user ability to troubleshoot issues that might occur during refreshing of the data.
Atif