Forum Discussion
dataset refresh error: can't find column
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.
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:
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.
4 Replies
did you republish the app after this?
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
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.
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:
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.
