Forum Discussion
Unable to refresh Excel Hosted in Power BI Report Server
Hi, I have an Excel saved in Power BI report server web portal that connects to SSAS cube. When i refresh the pivot it throws the following error: "This workbook contains external data connection...
Ccparkhill
Helper II
Helper IIIs the machine account of the OOS server an SSAS admin? This link might help:
https://docs.microsoft.com/en-us/power-bi/report-server/excel-oos#using-effectiveusername-with-analysis-services
https://docs.microsoft.com/en-us/power-bi/report-server/excel-oos#using-effectiveusername-with-analysis-services