Refreshing OneDrive for Business Excel Files with data model and Linked table

Hi Anonymous,

Based on my test, I uploaded a Excel file to OneDrive for Business which contains a table data without any external connection. In Power BI Service, connect to Excel via "Connect, Manage, and View Excel in Power BI". Then I edit the Excel to add data model and pivot table. Back to Power BI Service, refresh the workbook and PivotTable displays. See:

If I connect to Excel via "Import Excel data into Power BI", and create a report from this dataset. Then edit Excel to create data model and PivotTable, and back to Power BI Service to refresh the dataset via "Refresh Now", the unknown error will throw out and data model structure will not updated in the dataset.

In my opinion, Excel table and data model are different things, Power BI dataset can't update table to data model structure. So you need to re-import data model to Power BI again.

In addition, if your want to change workbook from the table to data model instead of change table data, please use "Connect, Manage, and View Excel in Power BI" method, as in this way refreshed data goes into the workbook's data model on OneDrive, or SharePoint Online, rather than a dataset in Power BI.

Reference:
Refresh a dataset created from an Excel workbook on OneDrive, or SharePoint Online

Best Regards,
Qiuyun Yu