The December 2022 release of Power BI Desktop includes three new DAX functions: OFFSET, INDEX, and WINDOW. They are collectively called window functions because they are closely related to SQL window functions, a powerful feature of the SQL language that allows users to perform calculations on a set of rows that are related to the current row. Because these functions… READ MORE
Today I want to show you how to implement an auto dataset refresh after a dataflow is refreshed. On order to this, we use Power Automate. Let’s say that after an Iowa_Liquor_Sales dataflow is refreshed we want to refresh an Iowa_Liquor_Sales dataset automatically. So, create a New flow and choose an Automated cloud flow option. Choose a When dataflow refresh completes trigger. After creating the trigger, you are… READ MORE
Below are the steps on how to use Power Automate to schedule a refresh of a Power BI dataset at the time you want it to. I have recently seen some questions in the Power BI Community with regards to refreshing Power BI datasets. I thought it would be a good idea to blog on… READ MORE
In this blog post I am going to show you how I migrated an Azure Analysis Services (AAS) database to Power BI (PBI). This was inspired by the blog post: Accelerate your migration experience from Azure Analysis Services to Power BI Premium with the automated migration tool | Microsoft Power BI I thought it would be… READ MORE
I recently worked on two projects where the client wanted to show multiple metrics sliced by the same categorical data. For example, seeing how various metrics are performing over different regions or different product groups. A use case like this can be achieved in many ways; probably the best approach is to use small multiples… READ MORE
In one of the projects, I was working on, I received feedback saying it is hard to understand how many items they have selected in a slicer, and it is not the first time I came across this. It is a valid point, especially when you have quite a few items in a slicer, you… READ MORE
In one of the projects, I was working on, I received feedback saying it is hard to understand how many items they have selected in a slicer, and it is not the first time I came across this. It is a valid point, especially when you have quite a few items in a slicer, you… READ MORE
SharePoint and Power BI can work very well together. SharePoint can be a data source (lists), a container for data files (Excel. CSV etc in libraries), and as a dashboarding platform (pages). This demo rich session will explore all of these scenarios in great depth. SharePoint data can be finicky to retrieve, and this session… READ MORE
Recently I have been working where I have multiple accounts, and I wanted to test the different access to the accounts when connecting via Excel. Today we will discuss Changing the User Account in Excel when connecting to Power BI Premium/Per User or Azure Analysis Services. I could not find any blog posts or videos… READ MORE
I have been playing around with the new awesome (preview) feature in the December Power BI Desktop release where we can use DirectQuery for Power BI datasets and Azure Analysis services (link to blogpost) In my case I combined data from a Power BI dataset, Azure Analysis Services, and a local Excel sheet. The DirectQuery… READ MORE
