Power BI

In the Power BI service, you can easily look at refresh times for an individual dataset or dataflow. There are many different reasons why these metrics are important to you as a dataset or dataflow…

It has been a long time that I use SQL Server Profiler to diagnose my data models in the Power BI Desktop. I wrote a blog post in June 2016 about connecting to the underlying Power BI Desktop model from different tools, including SQL Server Management Studio (SSMS), Excel and SQL Server Profiler. In this … Continue reading Quick Tips: Registering SQL Server Profiler as an External Tool in Power BI Desktop

You know Power BI governance is important. And I know you’re busy. Need a little help on what to focus on? Consider enrolling for my Power BI Deployment and Governance workshop. I’m really excited about this format because I think it’s good bridge between random online searching for info and doi

Hello World... Welcome to 2021 Preppin' Data. Since Jonathan (@JonathanAllenby) and I chatted by a coffee machine in Feb 2019, we along wi...

Bring in the new year with an amazing set of Power Apps community all stars: Brian Knighting showing how to get started with Power Apps Portals and creating anonymous access solutions with the Power Platform. Demo Extravaganza all-star Deepak Shrivastava demystifying how to use Azure API management with the Power Platform and monitoring and simplifying Power Apps debugging by Microsoft’s own Hazim SharafelDin

Cascade Style Sheet or CSS in PowerApps is a capability that I wish will be part of a core feature of PowerPlatform someday. CSS has gone…

Power Automate Dataflow connector along with templates and sample scenarios you can get started with right away. The new connector provides a new way to react to dataflow events to take action on dataflows. Combined with other Power Platform Products connectors and the 400+ connectors available in Power Automate the possibilities are endless.

Use the GitHub Connector in Power Apps and Power Automate to run GitHub Actions workflows

Since its early announcement back in October, 2019, Monitor has helped thousands of Citizen and professional developers to efficiently troubleshoot and more rapidly solve issues they come across while building their Power apps and solutions. Now, we are excited to announce this tool is generally available (GA). We have introduced a new collaborative troubleshooting capability “Connect User” in Monitor to better facilitate team collaboration and troubleshooting.

Power Apps Icon SetThis set includes 2,000 free Power Apps icons in over 30 different colors from the Fluent Design System. All available icons can be found in the interactive icon finder above.1. Click …

The last update of 2020 is here! We know you are excited for this update, like a kid excited to open their presents. This update is our holiday present to you! So what is in the box? Read on to find out!

We’re excited to introduce a new datasets hub in the Power BI service and Power BI personal app in Teams. The datasets hub makes it easy to find, explore, and use the datasets in your organization. It provides information about the datasets as well as entry points for creating reports on top of those datasets or for using those datasets with Analyze in Excel.

We are excited to announce the general availability of read/write XMLA endpoint in Power BI Premium. With XMLA endpoints, Power BI inherits a large ecosystem of developers, partners, BI tools, and …

If you've been reading the Power BI announcements, you probably know already that there is a very exciting new integration with Power Automate: the Dataflows Power Automate connectors!For those of …

The idea for this new functionality was born out of thinking about how to improve the efficiency and performance of the Power BI scan so that it could support large numbers of data assets while still conforming to the security practices of organizations.

At Microsoft Ignite, we found out about Power BI Premium Gen2. It’s not available for you to use and WOW! It has changed the game! Adam walks you through what the changes are to help you level up. Docs: https://docs.microsoft.com/power-bi/admin/service-premium-what-is#power-bi-premium-generation-2-preview Performance video on Power BI YouTube Channel: https://www.youtube.com/watch?v=KMOrMmJ1_Ec

Microsoft newly announced a piece of very exciting news that Azure Purview now supports Power BI. This is massive news from a data governance point of view. Azure Purview is the next generation of Azure Data Catalog with more metadata discovery power and the ability to use sensitivity labels. After reading the news, I immediately … Continue reading Power BI Governance, Good Practices: Setting up Azure Purview for Power BI

Maybe you’ve heard of Azure Purview, the new Azure data governance service, that was released into public preview in the beginning of December 2020. Very often, when I want to test some new s…

PPU licensing brings all the sharing and collaborating of a Power BI Pro license but adds additional features, previously only available when purchasing Premium Capacity.

Where to go for best practice advice for Power BI: The Data Gods One of the most common questions I hear from customers and students is “what are your recommended resources for learning and s…

This article shows how to use calculation groups to change the active relationship in a model in order to let users choose among multiple dates. It is commo

We are excited to announce General Availability (GA) for Power BI Premium support for large models, along with additional new features, such as User interface enhancements, Multi-Geo support, and Bring your own encryption keys (BYOK).

After the announcement of the Azure Purview preview, the first videos published (Microsoft Mechanics and Simon Whiteley), my first Purview overview blog post it is now time to start with Azure Purv…

As I’m sure you’ve guessed by now I’m a big fan of dynamic M parameters in Power BI. They’re easy to use in Power BI Desktop but what if you want to use them in your own DAX…

With the introduction of the Power BI Premium per User licensing, it can be observed that most small to medium organizations have become excited about it more than anyone. The main reason for this …

These are the seventeen reasons why IT will not let me send my 250MB Excel file that we use to run the business via email At Ricoh Digital Services (AKA the day job) we do a lot of Data & Analy…

The most exciting feature of this version is that now with a few clicks you can clean up the Power BI model, but we have a few other things to add also; Exporting the result of DMV Partitions (Includes the M script of each table)Showing unused measures in the visualization tabshowing all columns/measures that their…