Forum Discussion
Issue in Refresh
Data source error: The '<pii>Column30</pii>' column does not exist in the rowset.
Cluster URI: WABI-SOUTH-EAST-ASIA-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 0082e34e-d191-4b11-be65-4d91104d7321
Request ID: ee6f5eaf-63be-1d4a-447c-5ba177f0d360
Time: 2022-05-17 10:05:07Z
Hi vinuth123 ,
Two scenarios where this error can occur:
Scenario1: When you modify the data structure in the data source, the refresh error occurs.
Scenario2: When you have pivot columns steps in query editor, the value in the data source has been modified, the refresh error occurs.The solution can refer to the following link:
This is the related document, you can view this content:
https://www.reddit.com/r/PowerBI/comments/nelldz/service_refresh_error/gyj32f7/
https://community.powerbi.com/t5/Service/The-column-does-not-exist-in-the-rowset/td-p/327629
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi vinuth123 ,
Most of the time when I see this error, something has changed in the data. Usually someone has changed the data column name for example. My usual detection method is to download the .pbix to my desktop, go to power query, and see what table is blocking the load.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
NathanielHi vinuth123 ,
Two scenarios where this error can occur:
Scenario1: When you modify the data structure in the data source, the refresh error occurs.
Scenario2: When you have pivot columns steps in query editor, the value in the data source has been modified, the refresh error occurs.The solution can refer to the following link:
This is the related document, you can view this content:
https://www.reddit.com/r/PowerBI/comments/nelldz/service_refresh_error/gyj32f7/
https://community.powerbi.com/t5/Service/The-column-does-not-exist-in-the-rowset/td-p/327629
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
