I had to connect multiple data sources out of which, one of them comes with the a .xls format. All the files reside in the organinzation SharePoint.
On PowerBI desktop it works perfectly, without any kind of data load issue. Once published and scheduled/manual refreshed, the following error comes up.
Locally the Engine is installed and it also working fine, the problem is faced just online, once published.
Is there anything which can be done, besides changing the .xls form
You may take a look at the post below.