Share your thoughts on DAX query view and Copilot to write and explain DAX queries (preview)

[DataZoe]

Hit Reply and let us know what you think of

• DAX query view
  • Release blog: November 2023 Release Blog 
  • Blog: Deep dive into DAX query view and writing DAX queries | Microsoft Power BI Blog | Microsoft Power BI
  • Docs: DAX query view in Power BI Desktop - Power BI | Microsoft Learn
  • Video: Boost your productivity with DAX Query View in Power BI Desktop! 

• Copilot to write and explain DAX queries
  • Release blog: March 2024 release blog 
  • Blog: Deep dive into DAX query view with Copilot | Microsoft Power BI Blog | Microsoft Power BI
  • Docs: Write DAX queries with Copilot - DAX | Microsoft Learn
  • Video: Copilot for Power BI: Your Ultimate Copilot Guide (youtube.com)

Thank you!

Fabric/Power BI Product Team

[johnt75]

It would be nice if DAX Query View respected format options set on a column, particularly on datetime types. At the moment it seems to be using default US date format and including a time value even if the column is set to Date type.

[DataZoe]

You can evaluate selected queries!

[johnt75]

Sorry Zoe, I don't see how that relates to my point. When I evaluate a query which includes a column of date type I'd like it to display the same way it would if I put it in a table or matrix visual inside a report. I know I could tweak the query to apply FORMAT to the column, but that would remove the ability to sort by that column, because a date formatted as text wouldn't sort correctly.

I would point out that both DAX Studio and Tabular Editor do this by default.

[johnt75]

There doesn't appear to be a way to turn off the new Sticky Scroll in DAX Query View. If you right-click within the sticky scroll area you either get the option to "Toggle Editor Sticky Scroll" or  untick Sticky Scroll. Neither does anything and you are stuck with sticky scroll.

[Mauro89]

Hi,

I like DAX query view, especially what it unlocks as additional developer capabilities. Best example seen up to now is from John Kesrki in how to use it for testing. 

https://www.kerski.tech/bringing-dataops-to-power-bi-part37/

[jdusek92]

Hello @DataZoe  ☺

I have the following feedback to make the DAX view even better:

currently I can right click/Quick Queries/[all the options here]

• either for single Measure
• or for all measures by right clicking "Measures"

I would like to be able to right click/Quick Queries on selected measures only.
it is already possible select multiple measures by Shift+Click, only the quick queries for DAX view is not supported for custom multiple items selection:

[DataZoe]

Thank you @jdusek92 for this one! We have this on our backlog.

[jdusek92]

Hello @DataZoe , any update on this? still not possible to Evaluate only selected queries, very limiting

[Gabry]

Would be better if copilot was available for PRO user or atleast PPU. Small companies or individuals can't have access to it. 🙂

[DataZoe]

Hi @Gabry ,

Thanks for this feedback! Unfortunately as a feature PM I do not get to decide these things. That said, one of the cooler things about the Fabric capacities is you can pause/resume them, and they do not charge while paused. I have an individual tenant where I host my Power BI reports for my portfolio and that is what I do when I am working with the Copilot features. This can give you some flexibility to try out these features. 

Pause and resume your capacity - Microsoft Fabric | Microsoft Learn

I hope that helps!

[Gabry]

Thank you for getting back to me. Can you confirm if the Copilot feature can still be utilized even when the subscription is paused?

The main concern is that the cost of an f64 or higher subscription is quite prohibitive for a small firm.

[DataZoe]

@Gabry When the capacity is paused, then the Copilot features would no longer be available. You will have to have it turned on to use Copilot features.