Power BI

<p>If you&#8217;ve started building responsive canvas apps by crafting size and position formulas on your controls, we&#8217;ve added some properties that may help you simplify your…

One of my clients called me the other day and asked whether it was possible to export the selected order that was selected in the current report page – as she wanted to send the information to another…

Learn about this innovative production implementation using Azure Databricks for a large retail industry client.

Find out how to get even more interesting data from Microsoft Graph API by adding another function to the custom connector in Power BI.

Does it take a long time to get your data refreshed in your Power BI model? Should you wait for hours for the refresh to finish because you have complex transformations behind the scene? Does the long…

If you're a Power BI Administrator, and particularly if you're responsible for administering a large and varied Power BI environment, you may consider investing time into the development of a Power BI…

Getting “Failed to load data model” for an Azure Databricks DirectQuery connection in Power BI? Adam hit it too and walks through how to fix it in Power BI Desktop using Power Query.

This is the first blog post in a series of posts that I plan to publish and share some of my demos that I presented during the Power Platform World Tour in Chicago last week (April 9-10, 2019). In tod…

This article will show how to create a custom SharePoint list or library using PnP provisioning template. You can use this approach to create lists or libraries of any complexity in SharePoint. For ex…

PowerApps is great but there are some limitations. One of these limitations is drag and drop. Wouldn't it be nice if you could drag a document into a PowerApp and then PowerApps uploads the document t…

Quick link to the Common Data Model poster on the CDM GitHub Repository. A nice one to print out. “Integrate and Disambiguate Data with the Common Data Model” – https://github.com/Microsoft/CDM/blob/m…

Let’s pick back up where we left off last week and continue building the workflow and finishing up our PowerApp! Create a Flow At this point, we have a functioning app that stores data in a SharePoint…

This is the third article in my series about how to make Power BI Premium more affordable for small to medium sized enterprises (SMEs). In my first article I explained the problem and the logic be…

A practical example on how to combine flat files (like csv, txt and other extensions) using Power BI / Power Query using the From Folder experience.

This article shows how to compute a measure that sums the values produced row by row in the visual into the visual total, instead of recomputing the total v

The error is caused by using a TRUE/FALSE expression, something that evaluates to TRUE or FALSE, to filter the table in a way that CALCULATE or CALCULATETABLE doesn’t support. So the error is saying y…

This is the first in a blog series on Power BI Premium Performance and how to see how much memory is being used in Power BI Premium

Re-assign your dataflows connections without rebuilding your dataflow? Pimp the dataflow connector in Power BI to make it easier to switch! Read all about it in my blog!

Today I’m here with some exciting news out of Microsoft with the public preview of Microsoft Virtual Desktop. Virtual desktops are not a new invention and they are currently offered by multiple vendor…

In the first part of this series, you learned how to create an exception reporting for a column in a table using Power Query in Power BI. In the second part, you learned how to initiate that process f…

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup133 2 Minute Tuesday: https://guyinacu.be/pbireportbuilder Patrick’s tech video: https://guyinacu.…

This article will show how to create a custom SharePoint list or library using PnP provisioning template. You can use this approach to create lists or libraries of any complexity in SharePoint. For ex…

Recently we announced the capability of creating Machine Learning models directly in PowerBI. This is powered by automated machine learning from Azure. You can create an ML model based on your data wi…

I made a PowerApp to help build better looking Canvas Apps. You can try it out here. And if you want a free copy you find it in the TDG Power Platform Bank here. At the start of the year I decided I w…

Previously, I have written about using Power Query transformations and functions to create an Exception report for Power BI. However, the method I mentioned there, was only doing the exception handlin…

Power BI Live Connect reports allow the dataset to be stored in Azure Analysis Services (Azure AS) or SQL Server Analysis Services (SSAS) while the report itself resides in the Power BI service. Re…

Reading Time: 4 minutes This past Tuesday, April 9, I was fortunate to present two sessions at the Power Platform World Tour in Chicago. The first session was Practical Tips for a Successful Power BI …

In this post, I am going to demonstrate a new custom visual that has been released by the AI team in Power BI in recent months. Before showing off the nice features, there are some key points about th…

Welcome back! In last week’s post, I promised to walk you through how to create a simple table report in Power BI Paginated Report Builder from a Power BI dataset. Why would someone want to do this, y…