Power BI

This blog post will show you how to create a new environment where you can explore and play with Power Pages lots more in Power Platform than beyond.

Dynamics 365 Sales Report Templates/Examples for Power BI I've released a set of free to use, open-source, Power BI reports for Dynamics 365 Sales. They are built to demonstrate using Power BI for Dynamics 365 Sales and help you jumpstart your own reports and data modeling for Power BI with Datavers

Microsoft and the Project Management Institute (PMI) are partnering to announce the Microsoft Power Platform University Hub. The University Hub teaches students how to solve a wide range of business problems with low-code—one of the fastest growing technologies in the job landscape today.

Welcome to the Power Apps monthly feature update! We will use this blog to share a summary of product, community, and learning updates from throughout the month so you can access it in one easy place. A variety of new and highly anticipated features are now available which we are very excited to share. We…

What are Dataflows and how they fit into the big Power BI data modeling picture? This article will demistify everything about the Power BI dataflows!

Today, most companies are still struggling to become more data-driven. Even though data is inseparably connected with change, there's very little focus on change management. This article examines the three main sources of resistance to data and shares five tips for leading data-driven change.

Here is the November release of the on-premises data gateway!

Welcome to the November 2022 update! This month we introduce an Optimize ribbon which makes your report creation experience more streamlined, especially if you are working in DirectQuery mode. Also new this month are Linked Metrics and a new EvaluateAndLog DAX function that enable you to log intermediate values of your DAX expressions. There is more to explore, so please read on!

Power up your knowledge and connections at the European Power Platform Conference! The 2nd European Power Platform Conference (EPPC) will take place ...

As part of a broad digitization strategy, Rabobank adopted Power Platform to streamline internal processes. Rabobank currently uses more than 2,500 Power Apps and Power Automate solutions, including solutions that reduced processing time from three weeks to three minutes.

I'll show you how Power Apps can send email including file attachments, rich text formatting, embedded images, HTML tables, web links & more

Power Apps drag and drop functionality is now available. We can use it to group, re-order and move objects in a gallery-like container.

Step-by-step guide! Thrive to enhance user experience by adding any of the three different visual user guides to the Power BI report.

Recently I had a project where I needed to display a room calendar in Power Apps. I explored a few ways of doing this, and in this post I’m going to show you how to do it using Power Apps, Power Automate, an Azure App Registration and the Graph API! A bit of configuration before we start some dev…

A checklist to ensure your Power BI App is structured, secure, well-designed and helps users find what they need to use your Power BI reports.

Something cool has just been announced for Azure SQL DB: the ability to call a limited number of REST APIs direct from TSQL. The announcement is here: There are code samples here: And guess what, t…

Power BI can handle large data volumes, but just how much data can you load into Power BI? Can Power BI handle big data? How big is “big” anyway? These are questions you may have when y…

One of the most popular topics I’ve ever written about here is the dataset refresh errors you get with dynamic data sources and the Web.Contents function in Power BI (see here and here for ex…

Power BI is architected to consume data in a dimensional model, with narrow fact tables and related dimensions. Introducing a big, wide table in a tabular model is extremely inefficient. It takes u…

Table partitioning has long been an important task in semantic model design using SQL Server Analysis Services. Since SSAS Tabular and Power BI models are built on top of the SSAS architecture, the…

When planning a Power BI solution, how can we plan for scale and growth? Like any technology, Power BI has limits but Power BI can manage a surprising large value of analytic data. We also have too…

The External Tools ribbon is a feature that has been available in Power BI Desktop since the July 2020 release.  This feature should be considered essential to anyone who is regularly working in the Power BI space.    In this article I recommend my top five External Tools, that I [...]Read More »

Thank you to everyone who made it out to PASS Data Community Summit! I have greatly enjoyed meeting so many fellow data nerds and have learned so much from all of you. Speaking in person is always …

Making multilingual reports in Power BI requires a lot of different elements. Translations can be added to PBIX files to translate column names, visual titles, etc. but these translations will not …

Smart date axis with Field parameters

People change jobs, move projects so that dataset is no longer part of their job. So another accounts need to take over that dataset.