Error refreshing PBI model via Excel

pawlowski6132 · ‎02-09-2021

So, I went the 'Analyze Excel' route and have an Excel Workbook connected to a PowerBI dataset.

When I open the XLS file in Excel Desktop locally and refresh, all OK.

When I move this XLS file to the cloud (O365 Onedrive for Business or Sharepoint, all NOT OK.

Thoughts? Error feedback is horribly inadequate.

thanx much.

GilbertQ · ‎02-09-2021

Currently it is not possible to refresh an Excel workbook that is connected to the Power BI Dataset or even an SSAS or AAS Cube.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources