Forum Discussion
Having trouble refreshing my data.
Hello,
I have this error when refreshing my data-
Data source error: The '<oii>Risk Or Issue</oii>' column does not exist in the rowset.
Cluster URI: WABI-NORTH-EUROPE-O-PRIMARY-redirect.analysis.windows.net
Activity ID: 4dff5871-cef8-4828-bc6a-b53f1760f350
Request ID: f02c139b-67e2-6de4-9908-a801e25b9b0e
Time: 2026-04-01 09:21:32Z
I'm new to powerbi- so can anyone tell me how to fix this?
thanks
Your query is explicitly referencing a column named Risk or Issue. Check any rename, column removal or change type applied step. It is possible that this colum has been renamed (completed renamed, change of case, removal or addition of spaces, etc. ) or deleted from the source. Also, please note that M, the langue in Power Query is case-sensitive so Aa is not equal to AA.
8 Replies
Your query is explicitly referencing a column named Risk or Issue. Check any rename, column removal or change type applied step. It is possible that this colum has been renamed (completed renamed, change of case, removal or addition of spaces, etc. ) or deleted from the source. Also, please note that M, the langue in Power Query is case-sensitive so Aa is not equal to AA.
Yes, but how do i fix it so my data refreshes?
Please share your Power Query - all steps- to understand it better.
I think you have rename the column name of the dataset or remove that column.
In the powerquery , check the change type step. Usually that step will reset the data type for each columns. Delete that step, this issue may solve.
Hi ashleighethel ,
Thank you for reaching out to the Microsoft Community Forum.
As mentioned by InsightsByV , could you please share your Power query steps, that will help us to fix the issue.
Do not share sensitive information.
Regards,
Dinesh
Hi ashleighethel ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
I only have the online version so i don't have power query- i had do redo the report- so all sorted
