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
Hijacking the R Visual
Power BI comes stocked with a great set of visuals that keep getting better (more options to do multiples, please)
Attention Accountants: Year-End CPE Options that Don’t Suck!
Happy Thanksgiving everyone! Normally I use this holiday as an excuse to post something off-topic, but this year, I’m gonna stay ON topic and share something I’ve been meaning to broadcast for awhile. I just haven’t had the time to catch my breath.
A different use for Power BI: Self-service refreshes and extracts to Excel while managing security in Power BI
Have you ever needed to get data out to an internal customer quickly to meet an urgent business need, in an easy to access, updateable format?
