Power BI

Recently I attended an excellent session by Andy Kirk on the state of data visualization for 2019. One of the tools Andy is most excited about is called Charticulator. For...

Deploying Power BI in a large enterprise is a complex task, and one that requires a lot of thought and planning. The purpose of this presentation is to help y…

I’m excited to announce that I will be offering a full-day pre-con about Power BI report design in the coming year called Bookmarks, brain pixels, and bar charts: creating effective Power BI …

In this post I show you a very quick trick to format Line Chart and Area Chart conditionally in Power BI. As this is a “Quick Tip” I’m going to keep this post really short. One of my customers asked me to show time series in line charts and area charts. But she want’s it … Continue reading Quick Tips: Line Chart and Area Chart Conditional Formatting in Power BI

What is a Gateway? An on-premises data gateway is software that you install in an on-premises network. The gateway facilitates access to data in that network. If you have installed the gateway already and are looking forward to updating it to the current version released by Microsoft, then this se...

I see you thinking about my title… I know Microsoft Flow is now renamed to Power Automate, but then my title just doesn't have the same flow of reading anymore @NickyvV speaker 4 of 8 at @DublinPUG #PowerPlatformWT A form, a Flow and a PBI streaming dataset walk into a bar. pic.twitter.com/Jr8WX...

<p>GA of the Improved data experience</p>

Visit the post for more.

Did you know, Analysis Services (the engine behind Power BI) keeps track of the number of referential integrity (RI) issues in your model? It uses this information to decide if some calculations ca…

THis blog post details how I saved over 40% on the dataset and memory size in my Power BI Model and how others could do it too.

Just wanted to share a M function that I just created to calculate the date from a Year and a ISO week number. The example data is the following Now the function I created can be called with the Ye…

Introduction: The blog walks you through how you can export items from a gallery into a CSV using Power Automate with a OneDrive for Business connection. Requirements: A Power App with a data connection to provide data for a gallery A Power Automate flow which data connection to OneDrive for Busi...

On-premises data gateway November release

In this blog we show you how to send a collection from PowerApps to Microsoft Flow.

<p>This blog post is a second part in a series on how to “Return an array from Flow to PowerApps.” It will cover a much more efficient solution: the “Request – Response” method. Inside flow, using the action of the same name, you will be able to return arrays of any shape and size to PowerApps. To make the most use of this capability, we will be applying the solution to executing a SQL query.</p>

How to and why to use the new AI features for text analytics, vision and more in Power BI Desktop / Power Query from Microsoft.

Power BI’s accessibility documentation has been expanded from one article to five new articles for you to explore. We hope that these new articles will help you learn more about how Power BI can empower your organization, report creators, and report consumers through accessibility.

Power BI table and matrix visuals can render SVG object elements in a column or measure to display in-line web content. You can build dynamic content like KPI indicators, databars and sparklines by…

Team file sharing and version control may be managed through Power BI workspace integration with OneDrive and SharePoint team sites. In this post, I will show you how to get started and setup a new…

This week’s Power BIte is the third in a series of videos[1] that present different ways to create new Power BI dataflows, and the results of each approach. When creating a dataflow by import…

Last month[1] at the Microsoft Business Applications Summit (MBAS), Power BI program managers David Magar and Swati Gupta showed off a new load assessment tool for Power BI Premium capacity workloa…

Visit the post for more.

Visit the post for more.

Visit the post for more.

Visit the post for more.

This week I am attending the Power BI Partner Bootcamp on the Microsoft Power BI campus and got to play with the latest AI capabilities. AI is becoming a gamechanger in Power BI as a catalyst for insights. With R and Python integrations, the Auto ML in Dataflows, Key Influencers, Decomposition Tree, and the new …

Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! This article shows why a st

This article shows a basic technique used to sort months according to a fiscal calendar, by using a couple of calculated columns and the “sort by column

For the world of Power Apps users, the Common Data Services (CDS) might be more understandable, however, in the world of Power BI users, we still have many who don't know what it is and what is the use cases of it. So I thought better to write about it in this article, and explain…