This blog is inspired by a poll I recently ran on Twitter about whether people hide the filter pane or not. It’s another one of those topics where I don’t feel there is a definitive right or wrong answer – yep, this is me fence sitting again. But as always, Read more…
Last year I wrote a blog on the pros and cons of using a measure table in your Power BI model – you can check out that article here: To Measure Table or NOT to Measure Table? – Greyskull Analytics Ultimately it comes down to personal choice, with neither option Read more…
It’s a milestone that seems to have passed by without any real celebration, but last month marked the first anniversary of the general availability of Power BI’s Premium Per User (PPU) offering. At the time of it’s release in April 2021 there were certainly a few blogs and articles knocking Read more…
Date Tables… yep that again. I’ve been here before when I blogged about whether you should use M or DAX to generate your date table in Power BI. But the real answer, once again referencing Roche’s Maxim is to do it further upstream in a Data Warehouse. Some source systems Read more…
Well, I’m home having spent a week at SQLBits 2022 at the eXcel Conference Centre in London. And it was frickin ace! If you were a fellow ‘Bits attendee I’m sure you’ll agree it’s a superbly run event. But if you’ve never been then let me tell you why you Read more…
Urgh! What a horrifically click baity title for a blog… Still, you’re here now anyway, so you may as well read on. I wanted to capture this as a blog as an aide memoire to myself as much as anything else, so I don’t fall for this RLS (or ‘Row Read more…
Although they‘ve been generally available for over two years now, it’s only in recent months that I’ve finally had some hands-on experience using Dataflows in the Power BI service. I think they’re a good addition and I can definitely see their value. The Power Query experience, with the query folding Read more…
Time to conquer the next great Power BI debate! By request of fellow PBI blogger Mr Bernat Agulló on Twitter (you can check out his blog https://www.esbrina-ba.com/ here) I’m going to dive into whether you should use Dax or M to create calendar tables in Power BI. In real life, Read more…
Who’d have thought it could be such a controversial topic?! The humble measure table. In one of her recent videos (that wasn’t even anything to do with measure tables) Ruth from Curbal made a throw away comment about not being a fan of measure tables (skip to 8:40 on this Read more…
This week was the annual Microsoft Business Applications Summit, or MBAS. What was previously known as the Data Insights Summit has been rebranded in recent years and now covers a wider section of Microsoft’s offering including the full Power Platform and Dynamics 365, and it is THE place for Power Read more…