Welcome to the July 2022 update. We are thrilled to announce the Error Bars general availability, Metric visuals and Datamarts updates, query performance and data hub improvements, Data in space augmented reality new mobile feature, accessibility enhancements for embedded reports. There is more to explore, please continue to read on.
Visualizing views in Dynamics 365 with Power BI is now generally available
We’re very excited to announce that the Power BI integration in Dynamics 365 and model driven Power Apps, which shipped as a preview last December, is now generally available. Dynamics 365 and model driven Power Apps give organizations the ability to quickly build essential line-of-business apps in a low-code environment, increasing agility and modernizing processes. Since these apps are all built on top of Dataverse, they’re backed by your core business data. With this integration directly on views, information workers are now able to tap into this data and explore it using Power BI’s powerful data analytics capabilities without ever needing to leave their app. Just click the ‘Visualize this view’ button and let Power BI automatically create a report on top of the exact data you were looking at.
ExecuteQueries REST API versus XMLA endpoints at scale
Power BI APIs can support you at any scale, but there is no one-size-fits-all API. The ExecuteQueries API is a great choice at small scale. For large-scale solutions, switch to XMLA endpoints and host your datasets on Power BI Premium.
Limitations of On Premises SQL Sources with the Microsoft Power Platform
On the surface it may look like Microsoft’s data gateway provides an even playing field between IaaS and PaaS approaches with regards to SQL hosting, i.e. you can run your database server in …
Non-Obvious Functional Behavior in Power BI Deployment Pipelines
I’ve been spending time lately trying to get a deployment pipeline to work for one of my clients and ran into a couple of non-intuitive limitations that I didn’t expect, so I thought th…
The improvements to the Power BI experience in Excel include a new user-friendly UI that helps users easily search for datasets to build reports in the Excel grid. Also, users can now directly navigate from Excel to the Power BI service to discover new data artifacts in their organization or get additional insights from Power BI reports.
Chris Webb's BI Blog: Measuring Power Query CPU Usage During Power BI Dataset Refresh
Some time ago I wrote a post about how optimising for CPU Time is almost as important as optimising for Duration in Power BI, especially if you’re working with Power BI Premium Gen2. This is …
Hiding measures by using object-level security in Power BI - SQLBI
This article describes how to hide measures from a group of users by leveraging object-level security in Power BI and Analysis Services. Power BI datasets a
You may have used the UNICHAR() function in DAX to return Unicode characters in DAX measures. If you haven’t yet read Chris Webb’s blog post on the topic, I recommend you do. But did yo…
Conditional formatting with thresholds in Power BI
Conditional formatting is an easy way to highlight values so report users can receive quick insights on the status of key metrics. In this post, I will be showing a way to apply dynamic conditional formatting on visuals with set thresholds. This will...
The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best. The SWITCH function in DAX is widely used to define different execution paths depending on the condition of an expression. A very common case is when we want to check the sta
Power BI Data Model Governance With Power BI Golden Dataset and Thin Reports
Read MoreTop Considerations for Delivering an Efficient Hybrid WorkplaceOver the last two years, the importance of optimizing efficiency and productivity in the Hybrid Workplace has become an …
Power BI - Service
DAX
Power Query
Data Visualization
BI Framework
