Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.