dataset refresh error: can't find column

[nickspizza]

I changed a column name in my data source and then I changed it in my Dataflow as well. My Dataflow doesn't show an error when I refresh it but my dataset gives me an error saying that it's missing the column that I changed. I'm not sure where to fix it except in my dataflow which has already been fixed and is refreshing as it should. 

[Anonymous · Accepted solution]

Hi  @nickspizza ,

I my opinion, if you change the column name in the data source, the data source will not find the column when the data is being refreshed, you can try the following:

• Try to re-create the connection with the data source,
• Or change back to the name of the column in the data source

This is the related document, you can view this content:

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

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.

[lbendlin]

did you republish the app after this?

[nickspizza]

I deleted the app because I use the reports inside a sharepoint site. I republished the sharepoint site now but the dataset still gives an error when I try to refresh it

[lbendlin]

Go through the steps again. Publish the pbix, update the app, do your SharePoint thing.

Note: if you deleted the dataset you end up with a new set of GUIDs and your users may need to be informed of the new links.