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.
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.
BI for Everyone: Tear Down the Wall Between IT and Business
President Reagan in his famous “Tear down this wall” address, asked for the Berlin wall to be brought down. Believing that freedom and security go together.
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.
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.
