Cubevalue function

[milangr]

CUBEVALUE Excel function does not work if I use Analyze in Excel extension.
But if I go thought Dax Studio, and then use the advanced tab > Excel, it works.

PBI version 2.86.727.0 64-bit
Excel version 16.0.13231.20372 64-bit

PBISampleCubevalue.zip

[marcosqlbi]

I am not sure about what is causing this. If you use "Convert to Formulas" in the PivotTable, it works correctly. When you write the CUBEVALUE manually it generates the error in your screenshot if you provide an empty string in the second argument. However, the same expression using DAX Studio returns "N/A" and not a valid number. While I agree that there is something strange, I'd like to know if you can provide an example where the result is a valid number using DAX Studio and an error using Analyze in Excel. Thanks!

[milangr]

The error on this image occurs when I start to type the second argument.

[milangr]

Here is a comprising.
Left part is from Analyze in Excel extension

[milangr]

Maybe the connection name poses a problem.

[marcosqlbi]

Good news - the reason for the issue was not the file name, but a property that is automatically enabled when the ODC file is imported and was not set by creating the local connection. Fixed in version 1.1.3.
Please, try to download the updated version from https://www.sqlbi.com/tools/analyze-in-excel-for-power-bi-desktop/ and let me know if it works correctly. I'll wait a few days before enabling the automatic update to verify whether there are regressions.
Thanks!

[milangr]

Its ok now.
Thank you Marco.

[marcosqlbi]

Thanks for the feedback!