Notes on Power BI, Fabric and AI.

Business Intelligence

Power BI Feature Update: Page and Bookmark Navigators

Hello P3 Adaptive Nation! Happy New Year, ring out the old and ring in the new! Speaking of ringing in the new, with all the hustle and bustle associated with the holiday season and the excitement of welcoming the new year, did anybody happen to notice the new feature quietly rolled out in Power Bi back in November to take the edge off creating and maintaining custom pages and bookmarks?

Read the article

Power BI

Power BI and Paginated Reports: Better Together

Today we’ll be concluding our 3-part series on Analysis versus Reporting, Power BI versus SSRS and Paginated Reports, and looking closely at our habit of using the word “versus” so liberally

Read the article

Power BI

Power BI and Paginated Reports: Have We Come Full Circle?

There are few stories as tortured and twisted as my relationship with Analysis and Reporting. In 2002, as part of the Excel team at Microsoft, I was introduced to the concept of Business Intelligence

Read the article

Power BI

“Head to Head” Comparison Infographic in Power BI

This is one of those things where I spent a lot of time figuring out how to do something non-obvious. And hey, that’s usually a good thing to share! Keeps others from burning needless time, pushes the envelope a bit, inspires “riffs” and improvements on the core idea, etc.

Read the article

Power BI

How Can I get a Lookup Table from a Slowly Changing Dimension (SCD)?

Your Power BI model is fed by a data warehouse, and you’d like to make some reports, but now your Customer table has several entries for each customer instead of one.

Read the article

Power BI

Power Query (M)agic: Parameters for Dataflows!

I’ll get to parameters for dataflows in a bit. To begin, let’s talk about dataflows. Dataflows are Power Query queries that live outside of Power BI reports and can be refreshed on a schedule within Power BI service.

Read the article

Data Strategy

PowerQuery(M)agic: Conditional Joins using Table.SelectRows()

In a recent project with one of our clients, we were attempting to categorize website visit logs, based on the visitor’s landing page.

Read the article

Power BI

Dynamically Embedding Web Pages in Power BI

It’s sometimes difficult to find things that Power BI can’t do. There always seems to be a solution no matter the task at hand. A little while ago I was wondering to myself if it was possible to embed a website inside of a Power BI report.

Read the article

Power BI

Comparing Rows in Power Query Part 1

It is straightforward to compare values between each row in an Excel table and the next row.

Read the article

Power BI

Using Dax To Handle Multiple Parent Hierarchies

A common accounting task is to consolidate the financial results of subsidiary companies into combined results of a parent company. A parent company can have one or multiple subsidiaries.

Read the article

Power BI

Automated Testing Using Dax for Power BI

How often do you think about quality checking your reports? Sounds about as fun as listening to a lecture from Ferris Bueller’s professor, right?

Read the article

Power BI

Disconnected Slicers With DAX Variables & SELECTEDVALUES

Hello P3 Adaptive Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and especially to screenshots.

Read the article