Power BI

Do you need to find the GUID of a Dataset in Power BI? No need to use the REST API! Here's an easy way to find that Dataset ID :)

High cardinality columns are often the problematic part of the data modelling in most environments, including PowerBI.Since PowerBI data model resides on columnar database, having high cardinality col…

Hi there, I cannot believe it is already February. This year is already starting to fly by. Please find below my weekly Power BI Round Up. Export to PDF & On Demand Email Subscriptions As you can see …

It’s not always obvious when you need a data gateway in Azure, and not all gateways are labeled as such. So I thought I would walk through various applications that act as a data gateway and discuss w…

(2019-Feb-06) Working with Azure Data Factory (ADF) enables me to build and monitor my Extract Transform Load (ETL) workflows in Azure. My...

In this video, Patrick looks at how to create a Power BI streaming dataset and use that to create a real-time dashboard. You can easily use something like PowerShell to push data into the Power BI streaming dataset. Demo files

Recently, I was helping someone on Power BI community forum on the issue of calendar over run while comparing values with last year’s data. I thought it would make a good article to share wit…

<p>Use a new advanced condition builder to have conditional logic based on And / Or statements in a flow. Peek into the JSON code of actions in the Microsoft Flow designer. There is a new featur…

We’re thrilled to announce that you can authenticate to Power BI with service principal (also known as app-only authentication), available by end of week in Public Preview. Service principal …

Bulk operations enable Power BI admins to perform repetitive tasks efficiently. Perhaps you need to add a new hire as a workspace administrator to all workspaces of the Finance department. Or maybe…

For the second week in a row, we’re continuing to build on the capabilities we’d promised to deliver in the October blog post around managed distribution of content. These two new features are both…

We’ve released a new version of Power BI Premium Capacity Metrics app, version 1.10.1.1, with new system metrics by workloads, and total active dataset size in memory metrics. CPU consumption by workload In the Power BI Premium Capacity metrics app, on the Resource consumption tab, you’ll see a new CPU Consumption chart. In addition to the overall capacity … Continue reading “Capacity management improvement and more granularity in the Power BI Premium Capacity Metrics app”

One of the nice things about the Power Suite (the term I generally use to refer to Power BI, Power Pivot, and Power Query; does anyone else have any good terms?) is that it can easily allow you to rep…

We all know that Microsoft Flow is part of the PowerPlatform. The PowerPlatform is a No-Code platofmr that helps Office 365 power users to create apps and processes using Microsoft Flow and PowerAp…

App makers like us often need to test apps in an incremental fashion to help progress the app design by validating formulas, expressions, data manipulation, control settings etc. Knowing the shortc…

The diverse collection of data connectors in PowerApps is impressive. There are over 250 different connectors available, not only from the Microsoft ecosystem but across the entire internet. You ca…

We've been helping lots of folk recently to build Flow's which extract SharePoint list item attachments and perform some form of processing, typically to convert to a single PDF document and share with a third party, or add to a records repository. The following tutorial is built around a very si...

As the number of users, apps and flows in a tenant grows, it can be hard to manage what connections are being used by which apps and flows. Use the PowerShell scripts below, which are built with the PowerApps and Flow Administration module, to discover which PowerApps and Flows use specific features like custom connectors/APIs, … Continue reading “PowerShell scripts to discover PowerApps and Flows with specific features”

Learn how to upgrade your previous version Common Data Service (CDS) database along with any canvas apps and flows that depend on it to the new CDS for Apps database. Or, delete your previous version CDS database and create a new empty CDS for Apps database.

Some big news! Or at least much bigger news. Canvas app SaveData and LoadData functions are now only limited by the amount of available app memory and local storage on a device. The previous limit of a few megabytes no longer applies. This is a huge improvement that will increase the stability of any app that … Continue reading “SaveData and LoadData Unleashed”

Yesterday I answered to a question related to parameters in DAX that could be useful to other readers who use DAX in Reporting Services (SSRS): how to manag

This article describes how to write DAX measures that compute aggregations or comparisons with past dates without showing or comparing future dates. DAX ti

Technical articles, content and resources for IT Professionals working in Microsoft technologies

Adam picks up on David Eldersveld’s blog about Power BI slicers versus filters and looks at if slicers are even needed now. The filter pane can satisfy a majority of scenarios. There are a few that it can’t. Which Power BI feature will you choose? David Eldersveld blog

In this weeks Power BI Roundup for 31 Jan 2019 I go over Time-Based scheduling for email subscriptions, Power BI Report Server & On-Premise Data Gateway.

A while ago I found myself wondering – as I often do about this kind of thing – about what the undocumented third parameter of the Excel.Workbook() M function (called delayTypes) actually does. I f…