Since users will need to refresh the dataset, and refresh for external connections is not supported in Excel Online, it’s recommended that users open the workbook in the desktop version of Excel on their computer.
Forum Discussion
Excel 365 to OLAP Cube in SSAS
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...
Hi Ajinkya,
Were you using Get & Transform to connect to the OLAP cube? What method were you using.
Are you then trying to refresh that file using Excel online?
Were you using Get & Transform to connect to the OLAP cube? What method were you using.
Are you then trying to refresh that file using Excel online?
Hi Wyn,
Thanks for your prompt reply.
So, in the 1st scenario I connected Excel desktop to OLAP through a connection string (Get and transform method, I guess) in Data tab on the ribbon.
In the second scenario. I used 'Power BI' plugin for Excel desktop in order to import data from Power BI.
In both the scenarios, refreshing the excel file from Excel 365 failed.
Thanks,
Ajinkya
- Are you loading the data into the data model or into a sheet in Excel?
I've not tried any of this but you may need to set up some of this in Sharepoint
https://technet.microsoft.com/en-us/library/hh525344.aspxHi,
I'm not sure, but most probably that's not an issue of connection to on-premises data source. You may create simple data model published on Power BI services, connect it to Excel and try to refresh from Excel Online. It doesn't work.
As said here https://powerbi.microsoft.com/en-us/documentation/powerbi-service-analyze-in-excel/
Analyze in Excel | Microsoft Power BI
That was publishes (more exctly updated) bit more than a month ago , don't think something changed recently. We don't use Excel Online in organization (people pushed to open in desktop), thus have no concrete experience.
Thanks for answering.
Our problem is that we can connect excel desktop to OLAP cube successfully. However, when users use multiple tabs and pivot tables, excel crashes or its very slow.
So, would using excel 365 solve this problem? If not then what else can be done?
Your help is much appreciated.