Dax query view not visible in Power BI Desktop with live connection

[FredrikJ]

Hi!

In the release video for Power BI June they are talking about Dax query view now is visible in Power BI Desktop with live connection. But i can't see the Dax query view with Desktop version: Version: 2.130.930.0 64-bit (juni 2024). Anyone who got the Dax Queryview in Desktop when live connected to a Semantic Model?

Regards

Fredrik

[darrenfishell]

A little frustrating, but this is possible in DAX Studio as well as in PowerBI Desktop (though with limitations). 

What perplexes me a little is that if you open a blank workbook, connect to a PowerBI Semantic model and then (while that connection is loading) quickly click on the Dax Query View tab in the left sidebar, you end up on the query view page with a live connection and it all works just fine. 

The easier way is just using DAX Studio, which you can do directly from your live connected workbook. This will also save the connection string for a given workspace, which you can use later to connect directly in DAX Studio. 

Another way into this query option against a live dataset is the PowerBI Studio extension from VSCode. Once you connect, you can right-click on a model to open that in an external editor. This doesn't work in Tabular Editor 3 (as it uses some Discover methods that are not allowed in a live connection), but it does still work on DAX Studio. 

[DataInsights]

@FredrikJ,

You can change your model from Live Connection to DirectQuery which enables DAX Query view. Click the bottom-right link "Make changes to this model", click "Add a local model", and click "Submit".

[FredrikJ]

Hi!

Yes but in the in the release video for Power BI June they say you should be able to do this without change to DirectQuery.

Regards

Fredrik

[DataInsights · Accepted solution]

@FredrikJ,

This is now available in the July 2024 release:

https://powerbi.microsoft.com/en-us/blog/power-bi-july-2024-feature-summary/#post-27650-_Toc16156541...