Forum Discussion
Cubevalue issues connecting to Power BI Dataset
Hi, Currently we have an on premise MDX SSAS cube set up for a number of Finance colleagues to self serve their own reports. Their preference is to use CUBEMEMBER and CUBEVALUE formulas to acces...
Seems that PowerBI and Fabric semantic models are very limited in regards to handling CUBEVALUE. Once more than 15 cells have CUBEVALUE it fails - even with an F128 Fabric Capacity. Worked for the worlds largest shipping company at some point with their entire management repport being generated with 50+ sheets in one workbooks consisting of houndreds of cell with CUBEVALUE being run upon clicking "Refresh All" working fine towards an On-Premise SQL Server Analysis Services...