Power BI

Split text by any (whole) string instead of any character (within a string) like in the native Text.SplitAny -function with my modified new version:

Hi everyone, it’s guest blogger Paginated Report Bear! Well, actually, Mr. Chris agreed to type for me since I don’t have fingers. Anyways, if you watched my intro video, I promised you all I’d ma…

Hit this link to download the new aMAZEing DAX Game. Phil Seamark has made another great game that you should definately check out. Hit the link to Download

In this week’s webinar the Report Server team will answer your questions about paginated reports for Power BI Report Server AND show you the answers live. Don't have any questions? Not to worry we will have the team pull out their favorite demo and show why you should start using paginated reports now.

This is a question that comes up all the time. Power BI licensing is not complicated but a common challenge is that the person who sets up a new Power BI subscription and tenant within an organiza…

A few days ago, I ran into a problem where I had to filter a product table by a dynamically set of columns – so in one solution it could be filtering by field x and y and in other solutions it had …

You might know that we can connect Excel to Power BI using “Analyze in Excel” feature. If this is something new for you – check out following video (3 min) By default, after click…

Have you ever had a similar situation where a REALLY important value of the file is in either a header or a footer section? Let me give you a clear example with the following file: In the image above you’ll see that we have 2 values in the header section right under the logo of …

Makeover Monday this week focused on a variation of the “Big Mac Index”, where costs for various activities are compared in different cities. The original article presented data in a st…

It’s been two weeks since Power BI dataflows became publicly available in preview, and there’s been a flood of interest and excitement as people have started exploring and using this ne…

There are two common misconceptions that I see related to Power BI dataflows and Power BI Premium. This goal of this post is to dispel both of them. Misconception #1: Power BI dataflows are a Premi…

In case you don’t agree with this guy from that meme, you should go to ideas.powerbi.com to let the dataflows team know what you think, and why. The “ideas” site is a feature voti…

Are Power BI dataflows a master data management tool? This guy really wants to know. Spoiler alert: No. They are not. When Microsoft first announced dataflows[1] were coming to Power BI earlier thi…

I got sent a challenge to recreate a report that a customer had built in Excel. They had constructed a Gantt-chart-like view of their projects and wanted to see how we could reproduce it in Power BI I…

Here is my weekly roundup, and whilst it has not been as busy as the past few weeks, there are still some awesome updates. Power BI – Help Shape the Future of Power BI I always think it is really i…

Today a quick one that I came across while writing a different blog post that I will blog later. I know we have talked about it again and again but...

In this video, Patrick looks at a small feature called slicer restatement in Power BI. This feature will help you to determine what was selected in a slicer. While this feature was added back in April 2018, we are betting that most folks don’t know slicer restatement.

In this week’s episode of Insight Quest, Brett, a BI consultant from Frontline Analytics, has been assigned tasks related to the programmatic management of Azure Analysis Services and Power B…

In today’s digital world, organizations use and work with several applications for multiple different reasons. Often, data is stored and maintained in different applications and exchange of data…

The more advanced Power Query/M developers among you will know about query folding, the way that the Power Query engine pushes as much of the heavy-lifting of a query back to a data source. You may al…

In this blog I would like to cover how you can automatically load all Power BI activity data into a database for detailed analysis across different workspaces. We are realizing this using and Azure fu…

A few weeks ago I wrote an article introducing dataflows in Power BI and discussed why you should care about them. There are a few questions that have been spinning around in my head since then, s…

Currently it is not possible to implement user impersonation in an embedded Power BI Report Server. However, like in most scenarios, there are workarounds..

DBAs can use PowerShell cmdlets to manage Power BI workloads. Learn how the Power BI-PowerShell combination provides an efficient way to manage data sets, workspaces and Power BI reports.

Ok, here's a post to piggy-back off of my post regarding inbox sweep rules! A common scenario for many organizations and users is the need to organize images or documents that are sent from external s…

Sum and Sumx are functions that often founded to be misleading for many Power BI users. As both functions are doing the aggregation, it seems a bit confusing what is the actual difference between thes…

In this post, we will see how to implement a cascading dropdown list within the PowerApps application for a list with the two lookup columns where it has to display only the parent values if there are any associated child items. List data setup: SharePoint list “CarGroup” with the following data. Tata Motors Fiat Chrysler […]