cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SureshM Frequent Visitor
Frequent Visitor

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 Regular Visitor
Regular Visitor

Re: Unable to refresh Excel Hosted in Power BI Report Server

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