Issue in Refresh

[vinuth123]

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

[Anonymous · Accepted solution]

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:

https://community.powerbi.com/t5/Community-Blog/Refresh-error-The-xxxx-column-does-not-exist-in-the-...

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

https://community.powerbi.com/t5/Service/The-HasUniqueRoleAssignments-column-does-not-exist-in-the-r...

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.

[Nathaniel_C]

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.
Nathaniel