Power BI

I was intrigued why Tableau and PowerBI have a different behavior when operating in a Direct Query Mode ( Tableau call it Live Mode), I always assumed it is just a driver difference, but it seems i…

A few months ago one of my colleagues at Microsoft, David Browne, showed me an interesting Power Query problem with how the Xml.Tables and Xml.Document M functions handle null or missing values. I&…

Recently, I have had a challenge at a customer, where a central teams maintains many dataflows in Power BI, to store their only and single version of the truth. However, this central team maintaine…

Did you ever experience a long waiting time while opening a Power BI Desktop file? There could be many reasons for that, but if you have calculated columns

Case I want to refresh my Power BI Dataset as soon as my ETL process has finished. I don't want to schedule my dataset refresh x minutes/ho...

Learn the importance of enabling XMLA Read/Write

Reduce the number of measure you create by using Calculation Groups in Power BI. This blog will guide you through to get started.

Have you heard about Azure Synapse Analytics! Is your data in Synapse? It’s so much more than SQL Server! Adam and Patrick look at why you should care about it! What is Azure Synapse Analytics? https://docs.microsoft.com/azure/synapse-analytics/overview-what-is

Azure Bastion is a fully managed jumpbox-as-a-service that provides secure and seamless Remote Desktop Protocol (RDP) and Secure Shell Protocol (SSH) access to your VMs in local or peered virtual networks. With native client support available on the Standard SKU for Azure Bastion, you now unlo...

Software developers around the world are embracing low-code as a powerful part of their toolkit — they look at Power Platform as the next layer of abstraction that reduces repeated work, adds to their skill set, and lets them focus their coding energy on the problems that matter most. The increased level of productivity is also changing the way these developers work with their users — as fusion teams creating a much more active and rewarding environment for building impactful solutions faster than ever before. Let’s meet a few of these developers and look at examples of solutions built using Power Platform along with Azure services.

We are happy to announce that the in-app notifications feature has reached General Availability (GA). 

This release has only a few new additions.But I really love these new features!

With Power Apps OnError property we can capture unexpected errors, display a custom message and log them for developers to review later.

This article focuses on communication tips in Microsoft teams to create a successful Power BI support channel when deploying in your org

Learn to extract any step in Power Query. How to extract any single step in Power Query. Extract a step from the middle in Power Query.

In this blog post I'm going to show you how you can create an Azure Function that will interact with the Power BI REST API. I choose PowerShell as the programming language because in my opinion it was a bit easier to authenticate with the Power BI service. For the development environment, I'm using

Power Platform Landing Zones Reference ImplementationThis user guide explains the Power Platform Landing Zones reference implementation, what it is, what it does, and how organizations can use it to …

Today, I’m excited to announce the general availability of database designer in Azure Synapse Analytics. The database designer allows users to visually create databases within Synapse Studio without writing a single line of code. The designer also enables users to explore database templates, customiz

CI/CD, Branching and other DevOps concepts are very beneficial when it comes to development processes for software or in IT in general.Unfortunatelly Power BI falls short when it comes to support some of the concepts of DevOps out of the box. In this situation external tools may come to the rescue an

When users click Analyze in Excel in the Power BI service, the generated Excel workbook is automatically saved to OneDrive for Business and the workbook can be directly opened in a web browser using Excel for the web.

CALCULATE is the most powerful and complex function in DAX. In this article, we provide an introduction to CALCULATE, its behavior, and how to use it. CALCU

I discuss the different ways you can make Power BI queries run faster, and whether you still need Azure Analysis Services or if the tabular model within Power BI is enough.

I am a fan of the viridis color palettes available in python and R, so I decided to make Power BI theme files for each of the 4 color maps (viridis, inferno, magma, plasma). These color palettes ar…

A new Power BI Custom Connector for the Power BI REST API. Just download the file and start using it! Is that easy!

A guide to making your Power BI custom connector for Power Apps and Power Automate

Two ways to build and deploy static websites with Azure

Hello, for the last 10 years, I have been writing on and of about my experiences on a personal site (like this one) and in that time, I have moved from platform …

I love WordPress, yet I wanted to see if I could generate a static site by using WordPress as a content management system.