Forum Discussion
Cubevalue issues connecting to Power BI Dataset
Hi, Yarters ;
You can delete a few CUBEVALUE formulas and try again; just now you have mentioned that it works fine for one formula and fails or errors back to refresh for multiple formulas.
As far as I know, it may be the size reason, for 1Gb is not just the size of the dataset, including some formulas and so on, it will affect the model performance. So you can try about 3 formulas.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-yalanwu-msft Thanks for the reply but that doesn't solve things as the requirement is to be able to use these formulas, and I am limited to just a very small number (less than 10 it seems). When I run a large pivot table from the same dataset it returns in less than a second so there must be something else affecting this but I am not sure where to look. Thanks