Forum Discussion
Data Source not being updated
Morning all,
i updated an Excel file by changing it's Sheet name. When i went to refresh the data it didn't work, so far it makes total sense.
I couldn't find a way to update the tab so i removed the Excel file and re linked it and... the old Sheet name is still showing preventing all other sources to be updated.
How can i remove that "ghost" link?
Thanks for your help
hi, Anonymous
If you change the data source name or column name, When you refresh the data, it will get an error.
You could change it in the Edit Queries and republish the pbix file to power bi service.
here is a similar post for you refer to:
https://community.powerbi.com/t5/Service/Datasource-column-name-changed/td-p/130395
Best Regards,
Lin
2 Replies
hi, Anonymous
If you change the data source name or column name, When you refresh the data, it will get an error.
You could change it in the Edit Queries and republish the pbix file to power bi service.
here is a similar post for you refer to:
https://community.powerbi.com/t5/Service/Datasource-column-name-changed/td-p/130395
Best Regards,
Lin