Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Analyze in Excel using EGW SSAS live dataset doesn't work

Although it is accessible in the dataset options, once i have downloaded the odc file (and updated the oledb provider to the latest RC3 version) Excel, after inserted my credential, is not able to connect to that and raises the error "The following system error occurred:".

 

Is it a limit of the Analyze in Excel feature or a bug?

 

 

Need Help
  • avive's avatar
    avive
    10 years ago

    Hi giampitz,

    Analyze in Excel for a report based on an on prem AS server is not yet supported. Blocking the option is the first step we are taking to avoid user frustration. Soon enought we plan to start working on an interim solution to create an ODC file that will include the connection string to the on prem AS directly.

    I will update when the solution is available in the Service monthly update.

    Sorry you had to go through this experiance, hopefully we will be able to make this scenario work for you soon

    Thanks

    Aviv

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Anonymous I get the same behavior, and it was working the last time I had used it.

  • avive's avatar
    avive
    Power BI Team
    10 years ago

    Hi giampitz,

    Analyze in Excel for a report based on an on prem AS server is not yet supported. Blocking the option is the first step we are taking to avoid user frustration. Soon enought we plan to start working on an interim solution to create an ODC file that will include the connection string to the on prem AS directly.

    I will update when the solution is available in the Service monthly update.

    Sorry you had to go through this experiance, hopefully we will be able to make this scenario work for you soon

    Thanks

    Aviv

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Hi avive,

       

      thank you for the answer!

      Ok about the ad interim solution but the chain will be complete only when published Excels will be able to work with Enterprise Gateway within the portal. :-)

       

      Bye,

      giampitz

      • avive's avatar
        avive
        Power BI Team
        10 years ago

        Analyze in Excel now supports AS on prem datasets, using an ODC that connects directly to the AS server on prem.