Power BI

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.

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.

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.

As the data volume is getting bigger exponentially, more companies are moving towards business dashboards. They save time, enhance the business process, and drive decision-making. However, designing and developing business dashboards is tricky. Many designers make critical mistakes, which can limit the effectiveness significantly. They are not aware of important things that must be maintained. …

How do you measure the success of your organizations data culture? We dive deep into define measure for success.

On Tuesday, March 8th, I will be delivering a training day at SQLBits 2022 called "Beginner's Guide to Data Integration using Azure Data Factory or Azure Synapse Analytics" 🤓

Scenario: As more and more reports are configured to be refreshed, sometimes you may encounter refresh failures. So we need quickly detect whether a dataset refresh has succeeded or not succeed. Based on such a scenario, we can then use PowerShell's related commands to get historical refresh records...

In this blog I show how to use PowerShell to automate the processing of multiple Power BI partitions, which is faster.

The Data Type in a DAX Column is explained in this detailed article from Greg Baldini. This can be observed when using Dynamic Ranking.

There are two options to model many-to-many relationships using Tabular and Power BI: you can use either a regular bidirectional filter relationship, or a l

Why Power BI refreshes time out after two/five hours and how to work around this

Power BI Dataflow security is managed at the workspace level, this means when you add the user to the workspace he will be able to see all the Dataflows inside the workspace and every table within.…

The DAX Engine can be a complex beast but with a little understanding we can tame it to work for us. Read on to find out how...

We are excited to announce new capabilities for Streaming Dataflows in Power BI.

This blog is a resource to develop an understanding of data analytics and to become more familiar with the industry terms.

Not sure what a REST API is? Or what you can do with them in Power BI? Find out how you can easily take advantage of them without having to write a bunch of code. Use PowerShell instead! REST API Reference Documentation https://docs.microsoft.com/rest/api/power-bi/ Power BI PowerShell Reference Documentation https://docs.microsoft.com/powershell/power-bi/overview Use Microsoft Flow, and other options, […]

We are thrilled to announce the release of Power BI APIs .NET SDK v4. The new SDK version provides clarity on the properties of Power BI artifacts returned by various APIs and makes it easier to use them,

On-premises data gateway (standard and personal mode) release for November 2021

Learn how to create a Date slicer in Power BI that filters based on the start/from and end/to date in the transaction table with an example.

Deployment Pipelines within Power BI Service are a strategic feature that allows users to better manage content across the development stages of their organizations. By leveraging this powerful tool, users can simplify the deployment process and ensure security of potentially sensitive data. In this article, we’ll breakdown the specifics of deployment pipelines, and discuss how you can best leverage this tool within your organization for optimal efficiency.

For anyone who read the title of this and immediately thought, “Oh no, I can’t do C#! Since when do I need to be in app dev to do...

Naive Bayes is a statistical method of predicting the probability of an event occurring. This blog demonstrates the usage of Naive Bayes in Power BI