Forum Discussion
Dax Query View Copy Table Output Garbled
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 b...
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
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.