Power BI

I had to do this for a client the other day, and I realized I hadn’t blogged about it. Let’s say you need to include data in a Power BI model, but the only source of the data is a matri…

Announcing Public Preview of new My workspace governance features that address some of the pain points of governing My workspaces for Power BI Service Admins

This feature allows users to export an Excel table from a Power BI report and keep that table connected to Power BI by refreshing it in the Excel grid.

It's LIVE! Are you dreaming of advancing your career by getting the most in-demand certificate? This course walks you through each and every topic necessary to master the skills required for the DP-500 exam (Azure Enterprise Data Analyst)

Too many organizations are still struggling to go big with Power Platform not because of limitations in technology, but because of their own outmoded ways of doing business, though I know of no other move that IT decision makers in organizations across the economy and around the world can make that

DAX is more than the name of my new puppy

My post on which languages to learn as a Power BI developer resonated with many people so I thought I'd take a step back and write about how to navigate the various facets of the business intelligence job market. Where language selection is effectively a tactical tool choice, in this entry we'll focus on the

Thanks to the latest backup and restore improvements, you can now restore a backup file even when the dataset size is near the Power BI Premium SKU limitation. You no longer need to be concerned that dataset size limits impact restorability. When restoring a dataset with the /forceRestore option, Power BI will try its best to perform the restore operation even when the available memory is limited.

Now you can embed entire Power BI organizational apps in Microsoft Teams tabs. By adding Org apps in channels and meetings, you enable everyone to access the data they need.

Performance tuning is usually a complex and iterative process. This article provides an insight on the most common scenarios and how to leverage various concepts and techniques to optimize the performance of Power BI solutions

Proper use of table distributions in Synapse Dedicated SQL Pools is easily the #1 shortcoming in Synapse implementations.I regularly see large queries that t...

New year, new features! We are excited to announce the general availability of the Viva Goals Power BI integration and three new Metrics features specifically answering common customer asks. A new, optional column for milestones, scorecard time zones, and a handy auto collapse / auto expand feature.

There is an abundance of APIs around us, and we use them in our daily routine without thinking about them anymore.

How to use the Query option of the OData.Feed function in Power Query and Power BI

Today, we are excited to announce the public preview of Power BI Dataset Scale-Out, a dataset feature enabling enterprise customers to support large-scale Power BI solutions without any additional administrative overhead or infrastructure complexity.

Extension for Visual Studio Code - Power BI Extension for VSCode

Important disclaimer for this article: my whole blog and this blog post is unaffiliated with Microsoft; any opinions or comments expressed in here are my own. Power BI is a powerful tool for creati…

Learn how to create a Custom Page Dialog for Model-Driven Apps with this Task Generator example. Generate consistent Tasks but the user decide which will be generated!

This article will walk you through the different ways of how to monitor serverless SQL requests. By reviewing this article, you will understand what to see, compare and how to troubleshoot the query execution behavior. At the end of this article, I will also share how to create a solution to retain ...

This page presents examples of Vega data visualizations created by Andrzej Leszkiewicz Vega is a declarative language for creating highly customizable interactive visualization designs. Vega … Read More

What will the next era in data look like?

This shows how to put your entire query into Power Query Advanced Editor allowing you to see the entire query.

For many people, data storytelling is just an extension of data visualization. Most of the focus is spent on the explanatory data visualization techniques that are employed in data stories. By focusing primarily on the visuals, the two other key elements of data stories--data and narrative--are often misunderstood and overlooked. It's time for organizations to embrace a more balanced approach to data storytelling that is centered around the effective communication of insights, not just the data visualization aspects.

Implementing Data Contracts for Entities

Get started with an introduction to metrics in Power BI

Have you tried creating a virtual table and found it too difficult? Do you wish you had an easy way to integrate external data from SharePoint and SQL into Dataverse? We are excited to announce that makers can now create virtual tables directly in the maker portal in just a few minutes using a guided…

ABSTRACT 📄 As chatbots become more prevalent in the business world, many companies are wondering if ChatGPT is just a passing fad or if it has real staying power. A new tool that has the potential to help us streamline our workflows by providing automated assistance with tasks such as data model

We’ve just released support for implementing native query support in your own Power Query custom connectors through the use of the Power Query SDK. This new support allows Power Query connector developers to implement support in their connectors to enter a native query that can run against their data sources through the use of the […]