Power BI

What is Azure Data Factory and how can you use it? In this visual guide to ADF, we break down the what, why, and how of using ADF for data integration.

Get a beginner-friendly deep dive into what Azure Data Factory (ADF) is and how to use this Microsoft serverless data integration solution. Let's dig in!

In this post, we use Azure Synapse Analytics pipelines to ingest LEGO datasets into our data lake and then explore those datasets using Serverless SQL.

Learn how to add variables and not just hard coded data to DataTables on Microsoft's Power Automate Desktop

Requests limits and allocations

Infographic with PureViz modifying position and percentage fill

Calculation groups are one of the most powerful features to reduce the data model complexity and measure redundancy!

What?! Exploding Measures I hear you say. Exploding, expanding, use which ever word you like; what I mean is when you want to remove any refence to a measure INSIDE another measure. Example Consider the 3 measures below. Total Sales = SUM(Sales[ExtendedAmount]) Total All Product Sales = CALCULATE([Total Sales],ALL(Products)) % [...]Read More »

While Power BI is a SaaS service, backing up your dataset is still important. What if something was accidently deleted? How do you recover it? Patrick shows you how you can get a backup / restore process in place so you can sleep at night. Backup/Restore PowerShell Script: https://guyinacu.be/backuprestorescript Backup and restore datasets with Power […]

Updated on 11-apr-2022 Added an OnChange event triggered every time your click on an icon to change the form factor. The FormFactorSelector component, once added to your app's screen, will allow you to change LIVE the form factor of your screen while working within the Power Apps Studio. You will f...

Learn how Fluent UI combo boxes differ from the classic ones. Uncover a hidden feature that limits the data brought into an app!

Canvas apps are a great way to cover simple, as well as complex needs of business users. As a maker of such an app, you probably have a precise idea of how the app, buttons and functions should be …

Understanding the difference between row context and filter context is the first and most important concept to learn to use DAX correctly. This article introduces the row context, and is part of a series of articles about evaluation contexts in DAX. Most newbies start writing DAX code by creating sim

This article is part of a series of articles about the basics of DAX. In a previous article, we introduced the first evaluation context in DAX: the row context. If you are not familiar with the row …

Enhanced Dataflow Refresh History allows you to leverage the managed dataverse tables to view and monitor your dataflow refreshes in your environment.

Power Platform API acts as a gateway or a single API surface that harmonizes the internal APIs from feature areas of the platform.  This results in a single endpoint (ex. api.powerplatform.com) for customers to use along with a unified set of Permissions and claims that can be requested from Azure Active Directory.

Power Apps input masks are an excellent way to make sure phone number formatting is always applied correctly as the user types

When developers like Mike! start their sentence with "this is probably really simple", you know that it rarely is. (No idea why he's so excited about his name though, I suspect there is some math flex in here). This is probably really simple, but anyone know how I would add an index to an array o

Last quiz answer: 4Check out the Leaderboard

Virtual components and platform libraries support for code components

$-Strings are an awesome new way to concatenate text strings in Power Apps by writing curly braces { } to denote a function or expression.

Use the cheat sheet to help you envision and build powerful Apps using Power Automate and Dataverse. Power Automate – Dataverse Cheatsheet Let me know in the comments below if I have missed anythin…

Session details page

Official Sites & Documentation Name Link Power BI Custom Visuals Gallery https://appsource.microsoft.com/en-us/marketplace/apps?product=power-platform%3Bpower-bi-visuals&page=1 Power BI REST APIs Documentation https://docs.microsoft.com/en-us/rest/api/power-bi/ Power BI adoption roadmap https://docs.microsoft.com/en-us/power-bi/guidance/powerbi-adoption-roadmap-overview Power BI implementation planning https://docs.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-introduction White papers for Power BI https://docs.microsoft.com/en-us/power-bi/guidance/whitepapers Microsoft Power Platform and Dynamics 365 product roadmaps https://powerbi.microsoft.com/en-us/roadmap/ Power BI guidance documentation https://docs.microsoft.com/en-us/power-bi/guidance/ Power BI Embedded Analytics Playground https://playground.powerbi.com/en-us/ Community

Learn how admins can get insights on users who are connecting to Power BI datasets from Excel with the Power BI activity logs

This post shows how to Show measures in tabular format with calculation groups. Getting format strings right is the trickiest part, and we find some limitations

Overriding calculation items in tooltips is not straight forward, but using calculation groups inside measures is a convenient workaround

I needed to pull some user data for an app that uses Intercom. While I will probably import the data using Data Factory or a function in the long term, I needed to pull some quick data in a refresh…

Circular dependency error is one of the most annoying things in Power BI data modeling! Learn why this is happening and how to avoid it