Error navigating Excel Workbook in PowerBI Service using on-prem SSAS Tabular datasource via Gateway

[RunarEmgaard]

Hi,

we have a number of Excel/PowerPivot reports using on-prem SSAS Tabular datasource. Is it possible to upload these reports to PowerBI Service and navigate/update these Ecel-reports?

While trying to navigate (using a slicer) or update the worksheet we get an error: "Updating of external data failed" and a referance to PowerPivot Linked Data connection.

The datasource in the Excel-report is: 

Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=xxx;Data Source=yyy;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error

We have the on-prem gateway configured, and a regular PowerBI report updates correctly using the same SSAS Tabular instance.

Regards,

Runar Emgaard

[v-yuta-msft]

@RunarEmgaard ,

This issue may caused by windows authentication failed, please check if the credential is valid. In addtion, to publish report to service, I would suggest you to use power bi desktop instead.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RunarEmgaard]

Hi,

the crecentials supplied works for the PowerBI Desktop report using the same gateway. We would like to develop new PowerBI reports, using the existing Excel files from our Sharepoint/PowerPivot solution is a temporary solution only.