Power BI

I have written previously a blog article that I explained in detail how I fetch the image URL from a website using Power Query. That method, however, is what I call a bit of a techie way of doing it because you have to look at the HTML code of the page. There is an…

Learn how to work with SharePoint Multi-value columns in Power BI! You learn the basics as well as how to set up the model to enable value filtering.

Often I see the need to manage URIs when creating a flow. Power Automate has 6 operations available that can make your life easier. Rather than using split functions to split a URI, there are bette…

Activity monitoring and troubleshooting with the new logging API is focused entirely on Power BI tenant events like dashboard, interactive and paginated reports views, deployments, errors and data …

In Power BI the Key Influencers visualization uses multiple linear regression models. Explore these models, what exactly they are, and how they work.

Visit the post for more.

<p>Office Integration features available with CDS.</p>

Static Tables created via “Enter Data” has non-readable code. This post provides a solution to that.

The following is a pretty common scenario that I’ve seen with flat files exported from legacy systems, but it also applies to multiple other scenarios. It uses the M language inside of Power BI Desktop / Power Query, but you can follow along without knowing that much about it. The scenario: a table that contains […]

Different modeling approaches can speed up performance of your Power BI dataset - albeit with the tradeoff of additional complexity. One situation is where users need to access a very large dataset, but typically apply the same set of filters - resulting in a small subset of rows meeting the needs of most queries. A sliced aggregate approach (implemented in the data model + DAX) can be used to make your models performant where they need to be, but still allow the full range of reporting.

This article describes the reasons why an Excel pivot table may be slow when using the Analyze in Excel feature of Power BI. Power BI uses the Analysis Serv

Back in May 2019, I introduced the Power BI Pixel technique to track usage on Power BI. In today’s post, I will share the detailed implementation steps to help you build your own Power BI Pixel and track users and the filter selections they make in your Power BI report. Note: If you care about …

This PowerApps tutorial explains, how to update data table columns in PowerApps. Learn PowerApps update data table columns

Power BI custom visuals may make your report slow to load

tl;dr – to kick of 2020 we’re starting a new BI Polar video series focusing on building a data culture, and the first video introduces the series. You should watch it and share it. Succ…

If you don't have a Power BI Premium capacity license, then you are limited to refresh your dataflows up to eight times a day, with the frequency of 30 minutes. The good news for you is that you have a way to do unlimited refreshes and with whatever frequency you like using Power Platform Dataflows.…

Learn the PowerApps gallery control filter with example and how to filter a PowerApps Gallery control based on Alphabetical order.

This is a mock-up in response to this question on the Power BI Community Boards and provides a concept for expansion rather than telling a particular story. This is an example building on Parker Stevens' excellent Dynamic Reference Line on X-Axis walkthrough, with a twist. Rather than having a singl...

I conducted a workshop in Florida recently, aimed at helping people to move from Business Intelligence to Analytics. I thought I’d post the slides here. If you have any questions, please get …

What is PowerApps Table function, how to create a table using the PowerApps Table() function. how to use GroupBy() and Ungroup(), Filter() Function, PowerApps AddColumns(), DropColumns(), RenameColumns() and ShowColumns() function. and how to create a nested table in PowerApps.

how to use PowerApps functions: Remove() and RemoveIf(), ForAll(), Reset() and ResetForm(), Navigate(), Back() and Exit(), Switch(), Select() and Distinct() functions.

The Postman app is useful as a developer if you want to send requests and see responses when interacting with Web APIs, as well as seeing what the calls actually do. In this post, we will look at how to call the Power BI REST API from Postman. First, follow the instructions here to register an Azure App to use with Power BI. Note the client id and secret. Next, … Continue reading How to Call the Power BI REST API from Postman

The Power BI API contains several useful pieces of functionality if you need to do interact with Power BI at a lower API level. Power Automate provides great automation features, and it’s only natural we would want to use the two together. Power Automate does have a Power BI connector, but we can get right to the Power BI API to unlock more features as well. Let’s look at how … Continue reading How to Authenticate and Use the Power BI API inside Power Automate

This post comes from a question following on from my Refresh a Power BI Dataset with a Button post which I shared on LinkedIn. The question was, “I wanted to refresh more than one data set in the power bi pro”. You could do this by building out multiple buttons, or you could do this by performing multiple actions within a single flow. You could also do this by calling the … Continue reading How to Refresh Multiple Power BI Datasets using Power Automate and the Power BI API

One new feature that was introduced in the December 2019 release of Power BI Desktop, but which wasn’t mentioned in the release blog post, is the “Diagnose Step” button on the Tools tab of the Powe…

INTERIOR: pan over cubicles of happy, productive office workers CLOSE-UP: office worker at desk NARRATOR: Is that Susie I see, giving Power Platform dataflows a try? SUSIE: That’s right! With…

Another year has gone by and it has now been 10 years since DAX was first introduced in late 2009. As usual, it is time to review the past year and to take