Power BI

Learn how to use the US Census API to return the average house hold income. Click here to learn how to call custom APIs in Power BI.

Simply adding more visuals to a report impacts performance, In this Tutorial learn how I tested this, and learn how to prevent your report from these issues

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...

Are you looking for cross-selling opportunities to increase your sales? This tutorial teaches you everyting you need to run your basket analysis in Power BI

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…

On-premises data gateway November release

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

I have explained previously how you can use the Table.Profile Power Query function to fetch the profiling data of a table, such as minimum value, maximum value, null count etc, and use it in a report page to inform the user about the quality of the data. However, that function doesn't provide you with one…