Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedJoin us at the 2025 Microsoft Fabric Community Conference. March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for $400 discount. Register now
In the May 2017 release of Power BI Desktop a new ‘report measures’ feature was released. It allows users who have connected Power BI Desktop to an external Analysis Services tabular model to write their own measures using DAX. These measures are stored within the report, and sent in the queries back to the underlying model. Any user who has access to query the model can do this – just the same as if they were using Excel or SQL Management Studio to connect to the SSAS server.
Analysis Services admins will want to know what report measures are being used against their models. If there are common measures, or measures used by many users, these should be considered as candidates to move into the central model itself. We’ve created a Power BI Desktop template that IT professionals with Analysis Services instance administrator access can use against SQL Profiler output to accomplish this. Download the attached file (created by Power BI's Will Thompson) and follow these steps:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.