List.Generate(): Create Tables from Thin Air in Power BI with M!
An article that includes a simple tutorial on how to create tables in Power BI with M written by the experts at P3 Adaptive.
Category: Power BI
Data Modeling for Power Pivot and Power BI
An article on Data Modeling for Power Pivot and Power BI as well as a brief explanation about what we do written by the experts at P3 Adaptive .
Sort Your Data on Load for Improved Compression
My last 2 blog posts have been about data compression – that theme continues today. In December I blogged about the basics of compression and impacts that columns have on file size and did some testing with randomised data.
Oh Em Gee: Embedded Power BI Dashboard, Google Analytics, Real-Time?
An article on what is possible with an embedded Power BI dashboard and Google Analytics from the experts at P3 Adaptive .
Restructure Your Data Table for Improved Compression
I was relaxing during my vacation thinking some more about column compression in Power Pivot.
Quickbooks Analysis via QQube!
For a couple years now, we’ve been quite a bit bigger than the two-person operation of our early days. Like I mentioned in a previous post, there are now somewhere between 15 and 20 people who work for us in some capacity ranging from full-time to part-time.
The High Cost of Poor Equipment
Over the last 12 months I have engaged with may people from lots of different companies on the topic of Power Pivot.
Giving Back: “Steal” this Reference Card!
A long time coming… The Finalized 8-Page “Reference Card V2” – Download it for Free Below Yes, this took me forever. I first posted about it more than
Interview with Kamal Hathi of Microsoft, plus “AMA!”
Director of Product Management, Microsoft BI
Share and Refresh Power Query & PBI Get Data with Local Links
The concept of parameter tables in Power Query will be familiar to some and new to others. A parameter table is a way that you can “pass” values to Power Query (and also Power Pivot) and these values can then be used in your queries and/or the data model.
Complex Customer Cohort Retention Using PRODUCTX
Post by Rob Collie First, a Few Quick Updates…
Power Query as an SSIS Alternative
One of the many things I love about Power Pivot and Power Query is that these tools have put BI into the hands of users