Unable to refresh Excel Hosted in Power BI Report Server

Question

Hi,&nbsp;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 connections or BI features that are not supported"&nbsp;The Office web apps server is already configured to allow external connections. Is there anything I'm missing?

ccparkhill · Answer

Is 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

Forum Discussion

Unable to refresh Excel Hosted in Power BI Report Server

1 Reply

Related content

Unable to connect to any of the specified MySQL hosts

Connecting to Australian-hosted Smartsheet data

Unable to schedule auto refresh

Unable to refresh data from table shortcut

PowerBI licence of options for hosted and non-hosted services