Power BI

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

In early 2022, Microsoft released a new activity in Azure Data Factory (ADF) called the Script activity. The Script activity allows you to execute one or more SQL statements and receive zero, one, …

As someone with experience in ERP systems and business intelligence, I am always interested in learning about new ways to extract and analyze data from these systems. In this blog post, I am excited to share my experience with using Azure Synapse Analytics and Azure Data Lakes to load data from Busi

Demos: How to create or migrate SharePoint pages with Microsoft Graph API and Power Automate and List Formatting Magic – inlineEditField and setValue for making list fields editable. Released Microsoft Graph Toolkit (MGT) – v2.8.0 GA plus 14 samples!

Power Platform Pipelines aim to democratize application lifecycle management (ALM) for Power Platform and Dynamics 365 customers by bringing deployment automation capabilities into the product in a manner that’s more approachable for all makers, admins, and developers.

Let's make code reusable