Forum Discussion
Modifications in Power Query not updating in Power BI Service linked via Local Drive
ibuhary,
Please put your Excel workbook on OneDrive, as stated in this official article:
"When you refresh a dataset created from an Excel workbook imported from a local drive, only the data queried from data sources is refreshed. If you change the structure of the data model in Excel or Power Pivot; for example, create a new measure or change the name of a column, those changes will not be copied to the dataset. If you make such changes, you’ll need to re-upload or re-publish the workbook. If you expect to make regular changes to the structure of your workbook and you want those to be reflected in the dataset in Power BI without having to re-upload, consider putting your workbook on OneDrive. Power BI automatically refreshes both the structure and worksheet data from workbooks stored and imported from OneDrive."
Regards,
Lydia
ibuhary,
Please put your Excel workbook on OneDrive, as stated in this official article:
"When you refresh a dataset created from an Excel workbook imported from a local drive, only the data queried from data sources is refreshed. If you change the structure of the data model in Excel or Power Pivot; for example, create a new measure or change the name of a column, those changes will not be copied to the dataset. If you make such changes, you’ll need to re-upload or re-publish the workbook. If you expect to make regular changes to the structure of your workbook and you want those to be reflected in the dataset in Power BI without having to re-upload, consider putting your workbook on OneDrive. Power BI automatically refreshes both the structure and worksheet data from workbooks stored and imported from OneDrive."
Regards,
Lydia
Hi Anonymous , i have linked my Power BI desktop to an Excel file in sharepoint. However, new tables or measures added to the power pivot data model are not refreshed in power bi (although new columns added to existing tables are indeed refreshed). Am i doing something wrong?
Re-Link your file from SharePoint, and replace your Dataset using the same name as you used before.
Refresh only adds data, but for structural changes you need to replace the Dataset.
Dont Worry it will not affect your reports and dashboards, as long as you didn't change any field names, already used in Power BI Service Reports.
If you encounter any Errors in any visual, edit report and click the visial and see in which field or measuire the error is coming from and replce it with the new one you have in your updated file.
