search

sql-bi / AnalyzeInExcel

Analyze in Excel for Power BI Desktop
MIT License
82 stars 16 forks source link

Cubevalue function #10

Closed milangr closed 4 years ago

milangr commented 4 years ago

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

image

PBISampleCubevalue.zip

marcosqlbi commented 4 years ago

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 commented 4 years ago

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

milangr commented 4 years ago

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

image

milangr commented 4 years ago

Maybe the connection name poses a problem.

marcosqlbi commented 4 years ago

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 commented 4 years ago

Its ok now. Thank you Marco.

marcosqlbi commented 4 years ago

Thanks for the feedback!