Power BI

Pre-computing aggregates from granular data to improve live performance for end users by using computing resources at scheduled times is a well-established software pattern. In this entry we'll look at how to set up aggregations across Microsoft business intelligence products. This functionality breaks the pattern of how most features have flown through the genealogy of

Learn about what is the Power BI REST API and how it can be used and what are the useful scenarios of it with links to study materials.

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.

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.

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.

If you run into an error when restoring a #PowerBI dataset in Premium, in this blog post I show you how to successfully restore the backup.

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

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.

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

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

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

One of the main challenges I see #powerbi admins of large enterprises is monitoring & troubleshoot all their on-prem Gateway Clusters. Each cluster has multiple gateway servers that are responsible to connect the Power BI service in the cloud to customer data sources, sometimes there are errors in t

Hope you’re all enjoying the fall! With the changing of the leaves comes a changed on-premises data gateway. Download the October version to use the same query execution logic/run-time as in the October version of Power BI Desktop.

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.

Do you have a a large dataset in Power BI Premium or Premium Per User? Do you have more than six tables that take a significant amount of time to refresh? If so, you may be able to speed up the per…

Extension for Visual Studio Code - Power BI Extension for VSCode

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.

What will the next era in data look like?

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

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…

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

Get started with an introduction to metrics in Power BI

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

ABSTRACT 📄 The Power BI December 2022 update included some exciting new DAX functions, that are all the buzz recently. Let’s explore these new functions using Tabular Editor 3’s DAX debugger to see what we can learn from them. GUEST BIO 👤 Daniel is a Microsoft Data Platform MVP and CTO of Tabul

Johnson Controls, a world leader in building smart, healthy and sustainable buildings, has more than 100,000 employees that require training which needs to be scheduled, tracked, measured, and analyzed. They saved 3,610 hours on backend process management and increased training throughput by 400%.

Sometimes it’s fun to think outside the box. Who knows, you might come up with the craziest ideas… Like I did this weekend 🤪 Raising the excitement It all started earlier this week when…