Forum Discussion

RunarEmgaard's avatar
RunarEmgaard
Regular Visitor
7 years ago

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

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

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    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's avatar
      RunarEmgaard
      Regular Visitor
      7 years ago

      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.