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...
Yarters did you find the reason/solution? I am having the same issue
hi CarolinaM91 I didn't really no. I'm stuck with a SSAS cube for now but fortunately it's not urgent that I swithc that off just yet, but I do want to remove it at some point in the future.
I refined my dataset considerably and it runs better, but not good enough for my needs. My belief is that it is due to using shared resource and hitting the limit of 2GB for the query within the Power BI service. I intend on using the Fabric 60 day trial capacity and seeing if when published within that it works effectively.
With simple datasets it is functional, but I have a couple where a many to many join is unavoidable and so have this issue.