Power BI

Universal Data Platform. Live data access to more than 250+ SaaS, NoSQL, and Big Data Sources through SQL.

Data is the fuel that drives any modern organization’s growth. Yet, most businesses struggle to appropriately harness and use their data. Rather than taking an all-encompassing view of the data at their disposal, many businesses keep data siloed away in different departments. As teams attempt to navi...

Drill throughs in Power BI when multiple data points are selected aren't available, there is a way to work around the issues with the simple use of cards

This article explains how to set up your environment so that you can develop a Power BI visual.

A quick tutorial about how to add or modify static data tables (i.e. those created with Enter Data) using Tabular Editor 2 or 3.

In this article, we look at some tips to best use pbi-tools and how to automate pbi-tools execution in the background, using Power Automate Desktop flows.

GitHub Gist: star and fork data-goblin's gists by creating an account on GitHub.

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 …

Case In our last post we refreshed a Power BI dataset from within an ADF or Synapse pipeline. For this we used the IDs of the PBI Workspac...

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

In the April release of the SQL Database Projects extension for Azure Data Studio and VS Code (v0.16.1) we are introducing preview support for an SDK-style SQL project based on the package Microsoft.Build.Sql. The SDK-style SQL project introduces several advantages, especially for developers shippin...

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"

We’ve added two new templates to the Template Gallery to help you easily perform complex transformations on your data with Azure Cognitive Services.   PII detection and masking With Azure Cognitive Services, you can now detect and mask PII in your data. Learn more here.     This template calls the...

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. …

Azure Synapse Analytics is a limitless analytics service that brings big data analytics and an enterprise data warehouse into a unified platform. The Azure Synapse platform provides a unified experience to help you discover and explore your data quickly, so that you can find meaningful insights at s...

Today, I’m excited to announce the general availability of database designer in Azure Synapse Analytics. The database designer allows users to visually create databases within Synapse Studio without writing a single line of code. The designer also enables users to explore database templates, customi...

Azure Synapse Analytics April 2022 Update    Welcome to the April 2022 update for Azure Synapse Analytics! This month, you’ll find a highlight of the Spark 3.2 Public Preview, the new Dataverse connector added to Synapse data flows, a revamped exploration experience in database templates, and how ...

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.