cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SureshM
New Member

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 connections or BI features that are not supported"

 

The Office web apps server is already configured to allow external connections. Is there anything I'm missing?

1 REPLY 1
Ccparkhill
Helper II
Helper II

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-analy...

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Kudoed Authors