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...
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.
What version of Excel are you using ?
Can you confirm it's Get & Transform /power query that you are using.
If the issue is down to data size and calculation issues then it might be worth trying a machine that has 64 bit office installed and see if that helps. 64 bit Excel can use a lot more RAM from your computer.
Can you confirm it's Get & Transform /power query that you are using.
If the issue is down to data size and calculation issues then it might be worth trying a machine that has 64 bit office installed and see if that helps. 64 bit Excel can use a lot more RAM from your computer.
Wyn, if use live connection to the cube hardware shall not be critical. If load entire cube into the Excel data model - yes, that depends.
