Power BI

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

Overview of how to use log analytics in Power BI

After a short holiday break, it is time for a new blog post! This time about one of the most exciting functionalities in Power BI that has been released in the past release wave, Power BI Deploymen…

This week, I’ve presented at two conferences in Europe about Application Lifecycle Management for Power BI. During these sessions at DataMinds Connect and Techorama I’ve talked and demo…

Learn how to enable service principal authentication to permit use of read-only admin APIs.

Analyze, visualize, and report on your data using 92 new DAX functions when creating measures in Power Pivot.

I have been blogging about DAX since before Power BI was a product; I started back in 2014 and Power BI was first released as generally available in mid 2015.  Until about 2017, the only way you could build a commercially viable production reporting tool that used DAX was via [...]Read More »

Welcome to Microsoft Ignite 2022! This year’s event will be a dynamic experience with global in-person and virtual sessions where you can explore amazing new Microsoft products and features that will help you do more with less. Across the Microsoft Cloud and the Power Platform, you’ll discover ground-breaking technology designed to help you get more speed, productivity, and time to focus on what matters while reducing your costs. 

Our new cross-tenant dataset sharing capability is now available in public preview! This exciting capability allows customers to share their Power BI datasets with external users (consumers) in a way that allows these external users to access the datasets in their own Power BI tenant.

Power BI is a powerful tool that has also enabled millions of people worldwide to easily visualize & explore their data. Despite that, inflexibility to the visualization configuration and formatting can make it difficult to fulfill visual requirements. What are some of the biggest feature g

Recently there has been a lot of buzz on Twitter (at least in my circles) about Azure Data Explorer. Point in case: And I personally have nothing against Azure Data Explorer (ADX), in fact it's a tool I've been using ever since I found out it can be used for free.

Understanding how to work with templates in Deneb

Further reading and external resources for Deneb

Missing a trigger in Power Automate for when a Power BI dataset has refreshed? Then check out this workaround.

👂 Heard about Deneb but don't know where to start?💡 Tip for #deneb beginners... How import and export Deneb chart templates in Power BI (4 min)https://t.co/atT49JnwHOWhere to find chart templates in links below 👇#dataviz #Deneb #vega #powerbi— Kerry Kolosko (@KerryKolosko) October 11, 2022

data business intelligence bi machine learning mi professionals contractors azure Power bi analysis ETL ELT modeling automation training leadership

Many gauge visuals take-up a significant amount of screen real estate, and I wondered if Deneb/Vega-Lite could be used to minimize the required space. Here’s what I came up with: This example uses a number of optional Deneb/Vega-Lite components, including: a title block c/w subtitle a transform block to extend the dataset a layer block with 4 specifications as follows: a bar mark for 100% width background (target) a bar mark for progress width = actual/target; percent) (actual) color = gr...

Way back in 2019, I was fortunate enough to meet Jeffrey Wang while at the MVP summit in Seattle. Jeffrey is one of the fathers of the DAX language and as such he is a hero of mine. I sat through some presentations and discussions, and Jeffrey mentioned an idea [...]Read More »

After working a lot with buttons one begins to notice certain specific details. In this case we are going to talk about the navigation between pages and format of a button. For those who didn't know, Power Bi allows us to use measurements as functions in different format options. Among them we will ...

New September Release Power BI Report Server 2022

RANKX is a simple function used to rank a value within a list of values. Its use is simple, but it can be a source of frustration for newbies. In this artic

In a previous entry I explained at length the various ways to secure data in business intelligence products. In this follow-up I want to elaborate on which method(s) to use for what purposes. RLS vs. OLS vs. DDM Row Level Security (RLS) is meant to restrict the depth of what any specific user or group

This article describes how to enable the cross-highlight in Power BI charts using different dates for the same event, such as Order Date and Delivery Date.

Create Power BI Metrics (goals) scorecards

Ways we can get to the total's row in Table or Matrix visual using HASONEVALUE & INSCOPE functions in Power BI

Learn the difference between DirectQuery mode and Live connections in Power BI

Share the article

Just a joke. But it opens great data visualization possibilities. Everything (almost) is possible. You know the rules. Use arrows to move around the visual. … Read More

In this post I just wanted to show the ability to use the Delta Lake format that is very common now with Power BI. I will go over a quick example of creating the files to reference, building a view…

This step-by-step blog walks you through how to load large datasets in Power BI Desktop using parameters.