Forum Discussion

George9's avatar
George9
New Member
3 years ago
Solved

Dataset not refreshing from OneDrive File

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...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    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

     

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

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