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.
Content Type: Blog Post
Export Power BI Data with Date Range in Title
In Power BI, every visual needs a title. Titles not only makes it easier to manage items in the selection pane, but also provide context when exporting data. Without a […]
Siloed and Slow: What Happens When You Aren’t Using Power BI’s Data Model “Brain”
Last week’s post left off here: most BI still relies on the storage layer (SQL or its many cousins) to be the brain, and storage layers are terrible brains because they were designed for storage, not for analysis.
Data Models: Power BI Has a Brain. How About Your BI Strategy?
Alternate Titles Abound! I could have just as easily titled this post ANY of the following:
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.
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.
Are my people working when the work needs to be done? Headcount Analysis with Power BI
One of the nice things about the Power Suite (the term I generally use to refer to Power BI, Power Pivot, and Power Query; does anyone else have any good terms?)
DST Refresh Date Function Power BI Service
Quick tip for DST Refresh Date function Power BI Service. I’ll put the code up front, and explain it below.
Finding the Flow: A Beginner’s Guide to Microsoft Flow
For the new year, I have a question for you: What do you think of when you hear the word “Flow”?
Setting a Default Slicer Selection
I see a lot of Power BI users asking for the ability to set a default slicer selection in their reports
Cube Functions, the good the bad and how to make them great
I’ve written in the past about using the CUBE functions in Excel. The general pattern of the examples I’ve used was pretty consistent:
2 Tips for Visualizations in Power BI Dashboard
Here are 2 tips for visualizations in Power BI Dashboard. In Power BI service (PBIS) there are reports