Dax Query View Copy Table Output Garbled

[tecumseh]

Hi all,

Using PBIDS April, 2024
I ran on DAX Query View

EVALUATE
INFO.MEASURES()

Copied the Results Table
And Pasted to Excel A1

The first column should be ID
But toward the bottom of the table, I see some rows that are from the Expression Column.

I ran  select * from $SYSTEM.TMSCHEMA_MEASURES from DAX Studio
And output to a file.
Good to go now - but curious how to improve DQV.

Thanks,
-w

[tecumseh]

@LucaRocha 

Try to query directly from Excel see if that fixes the nbsp issue

Data
Get Data
From Database
From SQL Server Analysis Services Database (Import)

Enter Server, Database and past in your query

[LucaRocha]

Unfortunally my organization doesn't allow this type of connection or the use of third party solutions like DAX Studio. I can only connect directly to the semantic model and since the INFO. functions can't be used for creating tables in the model, my hands are tied. 

I'll try to work around this issue with Power Automate and I'll keep this thread updated.

[LucaRocha]

It seems like the output of the "Copy" button don't work as expected when you have long measures with line breaks (Shift+Enter in the formula bar). 

[Anonymous]

Hi @tecumseh 

Here are some suggestions:

Ensure that the data in your model is consistent and clean. Sometimes, inconsistencies in the data can cause unexpected results in the output.

Double-check the syntax of your DAX query and make sure it is correct. Even small errors can lead to incorrect outputs.

Since you already used DAX Studio to run `SELECT * FROM $SYSTEM.TMSCHEMA_MEASURES`, you can use it to validate your DAX queries before running them in DQV. This can help identify any potential issues early on.

Make sure you are using the latest version of PBIDS. Updates often include bug fixes and improvements that can resolve issues like the one you're experiencing.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.