Power BI

You NEED to be aware of how Publish to Web works in Power BI and how to prevent data exposure.

We are excited to announce the release of a new and improved usage report for Power BI reports in modern workspaces.

Recently I’ve been working with the Power Query team to come up with some ways to help developers understand the data returned by the new Power Query diagnostics functionality. In this, the f…

Aggregations is one of the key feature in Power BI and it helps to analyze large datasets without any performance impact.New to aggregations? read this to get a better idea. once we designed aggreg…

We all know there are lots of data sources; flat files like Excel files, CSVs that you import from another data source, connecting directly to a SQL Server or to SharePoint, or using a data warehou…

Sometimes we have data for many years in our dataset, but we want to restrict how many data points we want to show in #powerbi visuals at any given point. In this blog post, I talk about how you ca…

In this post we share our favourite tools to find and host images, and show how we incorporate these into Power BI reports!

Sometimes we have data for many years in our dataset, but we want to restrict how many data points we want to show in #powerbi visuals at any given point. In this blog post, I talk about how you ca…

Reading Time: 2 minutes Many organizations deploying Power BI rely on one or more standardized template (.PBIT) files. Especially when paired with a custom theme, templates help create consistency for branding or other reasons. Perhaps you want to open the same PBIT (or PBIX) every time you open Power BI and don’t want to rely on finding and opening…

Ever wonder which fields / visuals are used in your report. Stephanie Bruno has developed an amazing tool, the Power BI Field Finder for this, check it out.

Learn about using Power BI Layouts from PowerBI.Tips. This webinar from the Microsoft YouTube channel says it all. Click here to Learn more.

Quick one today. This question came up recently: “I only want to show values in a chart when someone selected a slicer”. Now this is actually not that hard, so...

The purpose of this post is to identify a number of behaviors and assumptions which may contribute to suboptimal Power BI projects and overall Power BI environments. A few symptoms resulting from t…

Do you need a custom legend for your Power BI visual and not sure how to put one together? Have a look at how you can build a legend for your conditional formatting. Download sample

In late January, Microsoft published the Power Platform: 2020 release wave 1 plan which lists all the new features that are targeting a release date before the end of 2020. The Power Platform ecosy…

BlueGranite has created a solution leveraging the Office 365 Management APIs to extract and store all available Power BI audit data.

Data is governed when it is: Trustworthy | Secured | Managed & Audited | Documented & Understood.

One of my favorite things to do in Power BI is get creative with bookmarking, and last week I received a question that made me think of this idea. Essentially, I was asked if it is possible to use …

Hello, powerbination! These days, sports statistics are one of the most demanded data types around the world. Betting, fantasy leagues, ads – are the great contributors of sports stats. Let’s look at the first (and maybe the simplest) task for all data pros who are facing this complicated industry –...

This post is about a tool which converts a Power BI dataset to a Power BI Dataflow. I have analyzed the internals of PBIT files and Power BI Dataflow JSON files in depth and created a PowerShell script which converts any PBIT into Power BI Dataflow JSON. TL; DR https://github.com/nolockcz/PowerPla...

In Part 1, I already explained what the reason behind this demo is, and what I used it for in my presentations. I made a start with the demo and showed you how to make a Form and set up a streaming dataset in Power BI. In Part 2 of this blog series I will show you how to glue it all together with Po...

January was a rockin month for us over at PowerBI.tips, we were itching to release as much content as possible after the holidays! Each month we release our newsletter which condenses all of the content we produce each month into a single notification. We'll be cross posting our content here on the ...

The purpose of this tutorial is to analyze and compare the market value of companies over time. To do this, we will see step by step how to download data from the Yahoo Finance site and then how to import this data into Power BI and process it in order to create a report. Step I: Downloading data ...

I have written multiple blog posts about how to create a date dimension using Power Query, however, the purpose of those blog posts was to teach you how to do it yourself, learn the process and also build the date dimension that you can use. Sometimes, however, you just want to create a date dimension…

Conditional expressions are one of the most commonly used expressions in any language as well as DAX. However, in DAX, if you have multiple IF THEN expressions, there is an easier way of doing it; using a function called SWITCH, this blog is about how you can use switch function in DAX and Power BI…

I have written another blog post about variables previously and explained how useful variables are. Variables in DAX are helpful in both readability and also the performance of your code. However, there are scenarios that you have to be careful when you use variables. Because variables are stored, they might return a result that is…