Skip to main content

Generate measure descriptions with Copilot (preview)

We are excited to announce the public preview of generating measure descriptions with Copilot! Adding descriptions to the model measures in your semantic model is an important model documentation step allowing report authors to understand what these measures do and how they should be used when creating reports. It is also a time-consuming task! Here the Fabric Copilot can help by generating the measure description for you to review and add to each measure in your semantic model.

To try this preview feature, you need to turn it on in Options > Preview features by checking the box next to Measure descriptions with Copilot.

The Copilot is available where you would normally add a description to your measure.

First, navigate to the Model view in the latest version of Power BI Desktop, or edit your semantic model in the Power BI service.

Second, click on a measure in the Data pane. You can use the Tables or Model Explorer in the Data pane. The Model Explorer has a Measures section, making it easy to find all the measures in your model no matter which table they are in.

Third, in the Properties pane, under the Description textbox click the Create with Copilot (preview) button!


Clicking the Create with Copilot (preview) button will check you have met the Copilot requirements, prompting you to sign in or pick a workspace associated with a Premium or Fabric capacity, if needed. Then, a Review the measure description from Copilot modal shows, giving you control over what happens with the description.

You can Try again to generate again, click Discard to not use the generated description from Copilot, or click Keep it to use the generated description from Copilot. You should be able to see the DAX formula in the DAX formula bar and the measure properties behind the modal to help you review the generated description. If there was a description already, that is also shown, and you can copy either the current or generated description with the respective copy icon.

I click Keep it and now the measure description from Copilot is added to my measure. I can modify this description or remove it by simply clicking in the Description textbox and making changes!

This measure description is visible in all views by hovering over the measure.




Comments

Popular posts from this blog

SSRS INTERVIEW QUESTIONS

Q: What is SSRS? Ø   SSRS or SQL Server Reporting Service is a server-based report generation software systems from Microsoft and is part of Microsoft BI. Ø   It is used for preparing and delivering interactive and variety of reports. Ø   It is administered through an web based interface. Ø   Reporting services utilizes a web service interface for supporting and developing of customized reporting applications. Ø   SSRS lets you create very rich reports (Tabular/Graphical/Interactive) from various datasources with rich data visualization (Charts, Maps, sparklines) Ø   SSRS allows are reports to be exported in various formats (Excel, PDF, word etc) Q: Explain SSRS Architecture? Reporting services architecture comprises of integrated components. It is a multi-tiered, included with application, server and data layers. This architecture is scalable and modular. A single installation can be used across multiple computers. It includes the fo...

Exception deserializing the package "The process cannot access the file because it is being used by another process."

TITLE: Microsoft Visual Studio ------------------------------ Failed to start project ------------------------------ ADDITIONAL INFORMATION: Exception deserializing the package "The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ While running SSIS package i got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”. I tried to close SSDT and run it again but, I still got the same error while compiling. Then, after searching over internet, I got...

Failed to execute the package or element. Build errors were encountered

Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element.   Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------   Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package