The Persistent Power of Pagination, w/ Microsoft’s Chris Finlan
Ep. 4-Chris Finlan offers his perspective as a Principal Program Manager on the Microsoft Power BI team
Search Results for: best practice
How Do You Know Your Power BI Security Roles are Right?
You need insights from your data, but you don’t want the wrong people seeing data that’s confidential or outside their responsibilities. In the Power BI service, there’s a robust way of ensuring that the right people get the data that they need for their purposes
Speed up your Power BI DAX formulas by up to 95% using the new OPTIMIZEDAX() function
This is an April Fools’ joke. OPTIMIZEDAX() doesn’t exist, but we hope the post gives you a laugh nonetheless.
Power BI Feature Spotlight: Using Bookmark Buttons to Create Pop-Up Windows
Hello P3 Adaptive Nation, welcome back to another exciting month of Power BI updates! This month’s release saw quite a few new updates and enhancements to the Power BI Universe.
Agile BI Moves from “If” to “How”
Eight years ago, I lucked into an epiphany: IT-driven BI was going to give way to biz-driven BI (aka “self-service” or “Agile” BI). The new wave of BI tools – led by Power Pivot at the time, which ultimately grew into Power BI – gave business subject matter experts something they’d previously lacked: the ability to execute directly.
PBI Spotlight: NEW & IMPROVED Tooltips
Hello again P3 Adaptive Nation! I’m SUPER excited today to talk about an updated feature in Power BI Desktop.
Announcing P3 Adaptive Seattle/Northwest with Power BI!
Hardcore “trying on” the Power BI label. Today, even our national practice is doing about a 50/50 mix of Power Pivot vs. Power BI work.
The Ten Pitfalls of the Data Wrangler (aka the Wielder of M/Power Query)
Ten Pitfalls of the wrangling of using Power Query and how to avoid them, written by P3 Adaptive , Rob Collie.
Break your DAX Problem into Manageable Parts
One of the concepts I discuss in my new book Learn to Write DAX, is that you should break your DAX problems into manageable pieces so that you can solve the problem one step at a time.
Nested SUMX or DAX Query?
I was helping a friend out recently with an interesting problem. It all started with a SUM( ) that wasn’t behaving.
Consolidated Worksheets with Power Query
The more I use Power Query, the more I want to use Power Query – and of course the more I learn.
The “Ferrari” of PowerPivot Books
UPDATE: My book, which explains the PowerPivot formula language (DAX), in down-to-earth fashion tailored to the Excel audience, releases November 6, 2012. I wrote it to fill the “DAX for Excel people” gap that existed between all of the previous books. People have been asking me seemingly forever to do this, I finally got around to it.