Hi Everyone. Let me know if this has been asked and answered somewhere else. I wanted to get your thoughts on organizational metrics. Specifically: - Has anyone tried out the new Metrics feature in Fabric? - If so, what are your initial thoughts on useability and organizational readiness? - Outside of this, how else do you manage Metrics and organizational KPIs? Here is some background 1. My team are building a catalogue of enterprise reports covering everything from sales to supply chain. 2. Each report has 1 - 5 metrics that are clearly shown and that 'anchor' the report to the overall organizational performance framework 3. Each metric should ideally display its current state, trend and variance to target. We are working on the data modelling to get the right level of history to make this happen so not every metric has this right now... but that is the plan 4. The holy grail has always been to have a high-level scorecard that displays all the metrics in a condensed format for management to fly over, flag as needed and drill through to the underlying report to answer any follow-on questions 5. In previous businesses and in the early days of Power BI we used dashboards and 'reports of reports' to try solve this. They key is ensuring there is auditability and the numbers match. The data modelling using direct query to the semantic models can get pretty ugly, especially if you are working with models powering many reports. We have also tried hanging a metric report off to the side by building specific metric tables in Azure. The challenge here is that depending on your pipeline refresh schedule, the numbers may be off from the underlying reports. There is also the technical overhead of maintaining metric logic in two places 6. My team have also tried setting up scorecards. Since they were released, they have shown great promise. They have the auditability nailed. The trend is more complicated since they rely on hard snapshots in the Power BI service. This makes them vulnerable to exchange rate adjustments and if you want to change a metric definition you cannot 'back map' the historical data. I also feel they are better suited for limited focus management of specific organizational problems where time is short and the business team does not have the luxury of waiting for a full data model to be developed. Trying to get scorecards to scale across many business units, functions etc. can be daunting. Even with the newer 'hierarchies' feature in place. Finally, the scorecard subscription service here is visually a dud😆. It's just not something that an executive will engage with. 7. You can get over that last point by a bit of hack, which is to build a report of scorecards. This is visually more appealing and you can set the subscription up as usual. However, this does create a BI 'click through' rabbit hole 8. Fabric metrics shows some promise and so I am interested how others have solved this challenge

Was curious what is everyones experience or preferred method of showing definitions of KPIs or other items in Power BI reports. An example would be say we have a KPI like Commercial of Lifts Per Hour which definition maybe number of lifts per hour for properties that have have min 25,000 sq foot per address. We may also include the formula Number of Lifts / 24 / 60 as well. In the past typically we have hard coded (not a fan) and also leverage a db to store and pull the information, 1) To put this manually on visuals in Power BI on hover, 2) We have added buttons that would do a pop up a little window showing this information. 3) We have added separate pages that pull up this information almost like a Help or Report FAQ page. With Purview and looks to be more integrated into Fabric are there better options for a data dictionary type of information to expose on the dashboard and reports for our customers? Curious on what some people have did and what there customers like, dislike?

Hello all! Has anyone had any experience pulling in Azure Monitor/Log Analytics data into Power BI Desktop using the Resource Graph Connector? I can pull a list of my resources, but it's not letting me view the tables or the records within the tables. I have Global Admin access, and can view it within Azure, but not via PBI.

Just saw this post on LinkedIn from Jon Stjernegaard Vöge on some new Governance features which are currently being developed - I'm glad Microsoft are taking this direction - looks very promising. Jon's post: "There were a few hidden gems revealed at hashtag#FABCONEUROPE yesterday, which were not shown at the keynote: 𝐅𝐚𝐛𝐫𝐢𝐜 / 𝐎𝐧𝐞𝐋𝐚𝐤𝐞 𝐂𝐚𝐭𝐚𝐥𝐨𝐠 and 𝐃𝐚𝐭𝐚 𝐀𝐜𝐜𝐞𝐬𝐬 𝐇𝐮𝐛 Two extremely promising governance features which will help patch some of the current shortcomings.I snapped a few (poor) pictures as seen below, which might give you an idea. 1) 𝐅𝐚𝐛𝐫𝐢𝐜 / 𝐎𝐧𝐞𝐋𝐚𝐤𝐞 𝐂𝐚𝐭𝐚𝐥𝐨𝐠 At-a-glance overview of governance status by Domain, Workspace and Item with suggested actions, and easy to browse lists and lineage views of all items. All of this searchable and filterable. Also seems like Domains in general will play a larger role in your architecture 2) 𝐃𝐚𝐭𝐚 𝐀𝐜𝐜𝐞𝐬𝐬 𝐇𝐮𝐛 Are you also looking track of which people have access to what? Microsoft is planning a one-stop shop for data access, where you can browse, review and edit all your user and item permissions in your data estate. Sensitivity Labels and Endorsements appear very integrated, and will play a pivotal role in this as well 🤝🧯The exact timeline and functionality for these appears unknown at this time, but I’m personally very excited! What do you think?"

Happy Friday everyone! I just released a new video describing my view on Analytics Engineering, the four areas that I think are most important, and how that might be different from what you learnt from the DP-600 exam. Take a look, would love to hear your thoughts: 👉🔗 https://youtu.be/of0Q8diezZQ Enjoy your weekend!