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

[giampitz]

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?

[avive · Accepted solution]

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

[giampitz]

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]

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

[flemaistre]

If we connect to a SSAS onprem dataset from PowerBI,  outside of our network, analyze in Excel will download an odc that needs direct access to tabular server. Why not having an odc with connection to the powerbi service? Could we use instead the olappump feature in IIS?

[avive]

Yes, we are aware of that scenario and we do have a desire to allow connecting to AS on prem through the PBI model, never the less this is work we do not have a timeline for at this stage.

i suggest VPN-ing into your network and directly connecting to the AS server at this time, or like you have suggested use the IIS feature to remotely connect to AS onprem through the web

[Seth_C_Bauer]

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