Power BI

Reading Time: 2 minutes If you’re a Power BI admin in charge of Premium capacity, you may rely on the Power BI Premium Capacity Utilization and Metrics template app to monitor your capacity. The current version of the app relies on a handful of...

In the first post in this series I showed how any Power BI dataset refresh started via the Power BI portal or API is limited to 2 hours in Shared capacity and 5 hours in Premium capacity, and how y…

With the December 2021 version of Power BI Desktop, as well as authoring reports in the Power BI Service, we can now add Sparklines to our Table and Matrix visuals. With just a few clicks you can make visuals that look like this:

Simulate a slow data source - making refresh slow - in Power BI

Back in June[1] the guys in cubes at Guy in a Cube were joined by Daniel Otykier and Marco Russo for a live stream on YouTube. Daniel is the creator of Tabular Editor, a powerful tool for developin…

To successfully implement managed self-service business intelligence at any non-trivial scale, you need data governance. To build and nurture a successful data culture, data governance is an essent…

We are excited to announce support for Hybrid Tables and Incremental refresh with real-time data in Power BI Premium to strike the right balance between query performance and data freshness. Now you can have blazing fast performance in import mode and the latest data changes in the data warehouse reflected in user reports without having to perform a dataset refresh.

Quickly hydrate your large models in Power BI Premium & Pro with on-demand loading!

Import mode and DirectQuery within the same table??? Yes, with the latest Hybrid tables features in Power BI, it's possible to get the best from the both worlds!

In composite models, any query can be executed on the remote model (wholesale execution) or by mixing local and remote engines together (retail execution).

Learn when and how to best use themes to create consistency in all your Power BI reports. Join us for the discussion.

Welcome to the December 2021 update, can you believe that it’s winter and the last month of 2021 year already? We are closing out the year with great new features, such as a new Sparklines preview feature, several new Format Pane updates, e-mail subscription access via Admin API and myriad of other useful features. Please continue to read on.

If your like me, you may have gotten a little over enthusiastic about calculation groups and dropped a number of them into a report page only to find that while dense with information, the report p…

If you spend a lot of time with Power BI, keeping up with what’s new and what’s coming is really important. The release plan is the product team’s official roadmap that’s published publicly . The release plan includes new features and enhancements that the product team is comfortable putting an

There are some really interesting things on the Power BI release plan. I'd like to call out a few of the top things that I’m most excited about. In this post, I’m focusing on a few release plan items that I think Power BI administrators in particular should be aware of as we head into 2022.

Blogging about Power BI, Power Platform and other things I find interesting.

I’ve been thinking about problem domains and solution domains a lot lately. I’ve posted on this topic before, but the more I think about it, the more I think I should explore it more. S…

People often struggle when using conditional formatting and calculation groups. If we think how calculation groups work there's many ways to use them effectively.

Sharing the NORM.DIST function in Power Query as a custom function here, as unlike in DAX it hasn't made it into the standard repertoire.

Discover how Databricks SQL is powering a new generation of analytics and data applications, running directly on the data lake, at the world’s leading companies.

Asynchronous refresh now available in Power BI for public preview. The asynchronous refresh REST API for Power BI brings built-in features for reliability, such as auto retries and batched commits.

The capability to pass custom data for row level security is now available in Power BI Premium, Power BI Embedded, and Power BI Premium per User.

Have you ever put together a report that has some really cool functionality and / or you just love the aesthetics and all you want to do is show it off internally to your colleagues… but it contains …

Learn how to use PowerShell cmdlets to export Azure Active Directory's user list and then import it into Power BI

Create and share color palettes for your UI, and measure the accessibility of any color combination.

Visualizing data in a view to get to interactive insights is a lot faster and easier, with Power BI quick reports available on model-driven apps’ view pages.

We’re very excited to announce a new way to visualize your model-driven Power Apps and Dynamics 365 data stored within Dataverse. With a single click, Power BI automatically generates a set of visuals for you to explore and find insights within your data. This integration is great way to take advantage of the full power of the Power Platform.