Power BI

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…

One of the known limitations with Components is that collections are not upported. The above link clearly states that Power Apps doesn’t support collections in components. Does this mean that…

Use Test Studio to build end-to-end tests, and maintain your app quality by continually validating your app works as expected when new changes are deployed.

Here are some of the expressions I have used to get the most out of using Forms Pro when sending and recieving surveys. It's all about that Power Automate!

Creation of a reusable navigation component for Power Apps.

Power Automate UI Flows January 2020 update is now available focusing on reliability improvements.

In the January 2020 update, AI Builder introduces a new and simplified way to use AI Models in Power Automate. It is now easier to provide your data to the AI Model, and to use the output without the need to manually transform data.

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.

We have already looked at some great features of Power Apps portals in previous posts, such as the out of the box templates such as the community portal template and customer self-service template. Now it’s time to look at creating a blank portal with minimal features, so organizations can build out a portal for their own specific requirements. We will look at how to customize the blank portal to include new … Continue reading How to Create and Customize a Custom Power Apps Portal For Your Organization

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…

AI Builder brings a huge change to creating smart self-service Applications. In this post we are going to see how to create a smart application that able to read the Business Card content and extract them, then import them using Power Automate to the Outlook contact list. Creat Business Card Reader using Power Apps and…