Posts

Write DAX queries with Copilot

Image
You can use Copilot to write and explain Data Analysis Expressions (DAX) queries in DAX query view of a Power BI semantic model. Enable Copilot In Power BI Desktop, in the  Preview features  section of the  Options , enable  DAX query view with Copilot . Open Power BI Desktop: Open an existing Power BI report or connect to published semantic model as live edit or live connection. Alternatively, you can add data and create a new semantic model and report. Go to  DAX query view , the fourth view available on the left side of Power BI Desktop. Create a new query tab. Open Copilot by clicking on the  Copilot  button or using CTRL + I. Power BI service or workspace: Choose a published semantic model in a workspace. From the context menu choose Write DAX queries. If Write DAX queries is greyed out, you may need to enable Users can edit data models in the ...