Power BI

The December 2022 release of Power BI Desktop includes three new DAX functions: OFFSET, INDEX, and WINDOW. They are collectively called window functions because they are closely related to SQL wind…

This video explains how to create a Bravo for Power BI template to customize a Date table and the related Time Intelligence measures created by the tool.

The filter arguments in CALCULATE can be written as logical conditions with certain restrictions. This article explains the more common errors in these cond

New window functions are one of the most important enhancements to the DAX language ever! Learn how to leverage them to calculate a customer lifetime value.

Explaining changes between snapshots is not easy, but calculation groups can help show exactly what happened in terms of Value changes, movements, etc.

Power BI Update - December 2022

I enjoyed testing the new WINDOW DAX function in Power BI with different use cases. In this blog, I will share with you some use cases of the WINDOW function announced in the December 2022 updates of Power BI . I tested the new OFFSET and INDEX functions 👉

There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The type of engagement you choose affects the pace and deliverables of the project, a…

Explore the many benefits of leveraging code and no-code analytics technologies during your analytics go-to-market strategy with this blog.

Learn how to build an automated and customized Continuous Integration/Continuous Delivery pipeline that integrates with Power BI using Azure DevOps.

Over the past month couple of months I got the opportunity to test out the new migration experience that was just made available for Public Preview this past month during the PASS Data Community Su…

Reading Time: 4 minutes The Power BI Gen2 capacity model significantly changed the way that Power BI resources are shared among multiple or reserved for individual customers. Attempting to draw a good analogy of how capacities work, however, leads to significant oversimplification. Simple analogies...

This blog discusses the different steps your organization can take to maximize the adoption of your dashboards, ML solutions, and analytics applications.

Licensing in Power BI os one of the most intimidating topics for the newbies. This article will demystify all the licensing options in a gentle and friendly way!

Over the last half year, I have been involved in many large migration projects from another BI tool to Power BI. All with a different setup, from Tableau, Microstrategy and from Analysis Services t…

In the previous post, I explained what content endorsement means in #PowerBI. In this post, how to enable #Certification in #AdminPortal and how to certify the contents.

I have some exciting news about the Power BI Deployment & Governance course. I'm thrilled to share that Mike Carlo will be taking over primary responsibility for the course as of Jan 1.

An introduction to the Power BI security planning articles.

What, How, When and Why on Power BI Governance!

Thoughts on why Power BI is a semantic layer and a metrics layer

Why using a column from a large fact table as a dimension could result in errors in Power BI DirectQuery mode

You can now create a subscription to a view of a Power BI report uniquely relevant to you. By selecting Include my changes, any filters and slicers you have selected will be captured in your subscription.

Cancel an in-progress dataset refresh in Power BI

Announcing new Power BI Metrics features hierarchies and linked metrics.

I love Excel as an alternative to Power BI reports, especially now that Excel Online allows you to interact with browser-based Excel reports that use Power BI datasets or the Excel Data Model (aka …

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

Learn how you can quickly circumvent the dreaded Formula.Firewall issue in Power Query without having to rework all your queries