Power BI Blog: DAX Queries Explained with Copilot

Welcome
back to this week’s edition of the Power BI blog series.  This week, we look at how Copilot can now
write and explain DAX queries in DAX query view.

With the latest updates, DAX query view
includes an inline Fabric Copilot to write and explain DAX queries,
which remains in public Preview.  You can
now do the following:

• Run the DAX query before you keep it.  Previously,
  the Run button was disabled until the generated DAX query was accepted
  or Copilot was closed.  Now, you can Run
  the DAX query then decide to Keep or Discard the DAX query

• Conversationally build the DAX query.  Previously, the DAX query generated was not considered if you typed additional prompts.  You had to keep the DAX query, select
  it again, then use Copilot again to adjust.  Now, you may simply adjust by typing in
  additional user prompts    

• Syntax checks on the generated DAX query.  Previously,
  there was no syntax check before the generated DAX query was returned.  Now, the syntax is checked and the prompt is automatically
  retried once.  If the retry is also
  invalid, the generated DAX query is returned with a note that there is
  an issue, giving you the option to rephrase your request or fix the generated DAX query    

• Inspire buttons to get you started with Copilot.  Previously,
  nothing happened until a prompt was entered.  Now, click any of these buttons to quickly see
  what you can do with Copilot.    

Try it for yourself!

In the
meantime, please remember we offer training in Power BI which you can find out
more about here.  If you wish to catch up on past articles, you
can find all of our past Power BI blogs here.