Dataset not refreshing from OneDrive File

[George9]

Hi all

I have an excel file on OneDrive and i link my tables into PowerBI online to create visualasitions of my data into a Report. Twice now in two weeks when refreashing my data the link to the data set seems to have gone missing or broken. The excel file is still in same one drive location and working fine but in powerbi it does not refreash or recognise the table names from the original file.

[v-yueyunzh-msft · Accepted solution]

Hi , @George9 

According to you description, You linked the Excel file for OneDrive For Bussiness on Power BI Serivce, but the refresh reported an error. Right?

Changes in data source table structure, or schema, such as a new, renamed, or removed column can only be applied in Power BI Desktop, and in the Power BI service they can cause the refresh to fail. 

You can check this:

(1) Whether the Excel file name is modified.

(2)Whether the changes in data source table structure, such as renaming/adding/removing the columns.

You can try to reconnect your Excel file to make changes to the schema.

Best Regards,

Aniya Zhang

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