Problem updating a table

[Florcita]

Hello everyone!

Every time i want to refresh a table, i get this error message:

The '<oii>createdBy</oii>' column does not exist in the rowset. 

What does it mean? How do i fix it?

Thanks!

[SamWiseOwl · Accepted solution]

Hi @Florcita 

Is the in error in the Query Editor (Transform Data)?

Try clicking on different steps and see when the error occurs.

You could also click Advanced Editor and copy the M code here.

I suspect when the connection was first set up there was a column called "Created by" which no longer exists.

[Anonymous · Accepted solution]

Hello,SamWiseOwl ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hello,@Florcita ,I am glad to help you.
According to your description, you are doing a refresh table in Power BI for a table where the [createdBy] column does not exist in the dataset, causing the refresh to fail.
Here is my suggestion, hope it will help you.
Your error alert indicates that the column "createdBy" referenced in the data source does not exist. This could be because the column has been renamed, deleted or moved. Any of these actions will cause the schema of the dataset to change and cause the refresh to fail.
You need to perform the following troubleshooting actions to check where exactly the problem is occurring:
1. Check the data source, you need to ensure that the "createdBy" column does exist in the data source. If the column has been deleted or renamed, or moved, you need to update your data source and query, and modify the report.
2. Update the query, open Transform Data in power BI Desktop, you can check each step to see which step of the data processing is the problem and modify it. You can open Advanced Editor to view and modify the M code.

3. Sometimes the cache may affect the refresh, clear your browser cache (for refresh on service) and the cache in power BI desktop, then reopen the file and refresh the data (for refresh operation on power BI Desktop).
4. Check your data model to make sure that no other queries or calculated columns depend on the "createdBy" column. If there are, update these dependencies to reflect the new column names or structure.
5. Republish the modified pbix file to the service, configure the gateway, and check that the data source certificate is correct.
Please make a good backup of your data when you perform these operations to avoid losing important data.
If the problem still exists after you have tried the above checks, you can share the screenshots of the pbix file of the table with the problem and the related errors of the data model structure, which will help to solve your problem.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SamWiseOwl · Accepted solution]

Hi @Florcita 

Is the in error in the Query Editor (Transform Data)?

Try clicking on different steps and see when the error occurs.

You could also click Advanced Editor and copy the M code here.

I suspect when the connection was first set up there was a column called "Created by" which no longer exists.