Power BI

Scripts for TE2 and TE3 to automate querying of DMVs to document your model.

In this post, we look at a simple way to extract the tenant settings from Power BI using Power Automate Desktop and a UI Automation / RPA flow. Inside, we have a summary of the settings and recommendations for each, as of April 2022.

Power BI usage scenarios: Advanced data model management11 minutes to read3 contributorsThis article forms part of the Power BI implementation planning series of articles. For an introduction to the …

With this external tool, you can double the number of Quick Measures available in Power BI Desktop!

TL;DR - If you're using the Dataverse connector (née "CommonDataService") in PowerQuery/Power BI, try adding the [CreateNavigationProperties=false] as a hint to dramatically speed up the "Evaluation" stage of a data import / refresh. (Note: This only is appropriate as long as you're not "expanding"

Really cool updates for #MonkeyTools for #Excel by Ken Puls from Skillwave Training . This is a “must have” tool for everyone using Excel on Daily basis...

TL;DR : When using SQL Queries against Dataverse, add the ‘[EnableFolding=true]’ option in Power Query to ensure queries are 'folding' back to the Dataverse service to gain dramatically improved …

In this folder, you will find the source code for the PowerBI app report on Dynamics 365 Business Central telemetry in Azure Application Insights.Note that the app is still being testing in a beta …

new data source and gateway management experience in Power BI

DESCRIPTION 📄 Do you have a lot of reports but are still searching for answers ? Do you really know what you are working toward? If so, we need to talk about Power BI Goals and how they can transform how you approach the question , where are we? GUEST BIO 👤 Treb Gatte is a bus

The Problem Most of you have probably run into a situation where someone in your organization has authored a report in the Power BI web service, and now they want to make changes that can [...]

An Open Source collection of Design Principles and methods

We continue to iteratively improve experiences that help you find relevant content and return to your work in the Power BI service. Upon hearing your feedback, conducting usability tests, and running …

So today Chris Finlan said a joke that I was posting a lot of positive things about my life as a PM, and so in this post I will explore a recent failure that I had in my career and what I learned. …

Aggregations are one of the most powerful features in Power BI! Learn how to leverage this feature to improve the performance of your Power BI solution!

Today’s my team and me had the opportunity to meet with one of our customers who had some features that they would like to be prioritized by Power BI. I wanted to spend some time today to tal…

Choose your favorite colors and get your Material Design palette generated and downloadable.

Learn how to design groundbreaking data visualizations and data products that people can’t live without.

Over the last few weeks we have been working on a Dataflow extension for our Power BI templates. The idea is to extract the existing queries from the

Do you know this message? "This file can't be downloaded yet. You can't download this file right now because it's been modified using an XMLA endpoint."

In this post, we will take a step by step approach to simplify a report with 6 pages + 12 measures into 1 page report + 1 measure. After optimising the report, we will explore a change that will …

Building a Dynamic KPI card with Calculation Groups allows to modify the base measure as well as the transformations to use for comparison.

Do you fancy a quick data visualization for your ad-hoc queries over SQL pools in Azure Synapse Analytics? Synapse Studio gets you covered!

Shared Datasets have been around for quite a while now. In June 2019, Microsoft announced a new feature called Shared and Certified Datasets with the mindset of supporting enterprise-grade BI within the Power BI ecosystem. In essence, the shared dataset feature allows organisations to have a single source of truth across the organisation serving many … Continue reading Thin Reports, What Are They, Why Should I Care and How Can I Create Them?

Struggling with using Row-Level Security (RLS) together with Object-Level Security (OLS) in Power BI? You think it can’t be done? Think again! Patrick shows you how to use both together. Announcement Blog: https://powerbi.microsoft.com/blog/object-level-security-ols-is-now-generally-available-in-power-bi-premium-and-pro/ Analysis Services Doc: https://docs.microsoft.com/analysis-services/tabular-models/object-level-security FourMoo: https://www.fourmoo.com/2020/05/26/did-you-know-you-can-now-selectively-show-report-pages-for-specific-users-in-power-bi/

This blog post shows the users all the Power BI reports they have got access to, and details the steps in Power BI Desktop.

Have you ever wanted to quickly visualize your data using built-in features in Synapse Analytics Spark pool? Check how simple and easy is to do that!

Learn the top five most common mistakes in Power BI development and how to avoid them to have a better Power BI solution.

This content applies to: Power Query Online Power BI datasets We are excited to announce three new features for the VNet data Gateway! New capability to create VNet data gateway clusters. You can use a cluster of virtual network data gateways to load balance the queries executing on the cluster and to avoid a single […]