Data Source not being updated

[Anonymous]

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

[v-lili6-msft · Accepted solution]

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

[Anonymous]

Thanks for the input, i manage to find where i needed to go to fix it 🙂