Connecting excel online to OLAP using Power BI

[arasam]

Hi Experts,

We, as a company are maintaining a OLAP cube in MS Analytical Services. We use MS SQL Server Management Services. I am trying to connect Excel 365 online to the OLAP cube. I should be able to refresh connection from Excel 365.

Things I have tried:

1. Connecting Excel 2016 desktop to OLAP cube (Successful) and opening the same file in Excel 365(Failed)

2. Using power BI:

a. Created an organization gateway.

b. Connected power BI to organization gateway(Success)

c. Connect Excel 2016 Desktop to power BI dataset (Sucess)

d. Upload same excel file online and refreshing the connection. (Failed)

PS: I am using the same user account everywhere. Also, I am added as a user to all gateways and OLAP cube.

Please let me know if there is a solution for this within the existing infrastructure.

Thanks.

[v-haibl-msft]

@arasam

Do you want to get data from the AS cube and publish to Power BI Service to make the data refreshed automatically? If yes, you can get data from AS through the built-in AS connector and publish/refresh through the on-premises gateway. Please refer to following two documents.

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-ssas-multidimensional/

https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-ssas/

Best Regards,
Herbert