Power BI
Why I Love Tabular Editor
Why I love Tabular Editor, my Tabular Editor journey, why you should be using it and how to justify its use in your organisation.
Dataflows
Power Query: Duplicate v Reference Queries
A topic that keeps coming up for me recently is understanding the difference between duplicating and referencing a query in Power Query. I felt it was worth while capturing my thoughts on how to explain the two. What do they do? When you duplicate a query it takes a copy Read more…
Greyskull Analytics
Mi casa es su casa – using a Power BI tenant as a guest
The “bring your own license” feature in the Power BI service is far from new. However it’s something that I have found myself using increasingly over the last few months. Being able to do work for a customer, creating and managing content, but without them having to pay for you Read more…
Power BI
Extending your Tabular Model Metadata
I’m a big fan of providing a Power BI Dataset with an accompanying data dictionary built from metadata within the model. You can see my method in this video from my YouTube channel. The dictionary I build is intended to be lightweight and aimed at report builders and consumers, so Read more…
Paginated Reports
Paginated Reports for Pro Users
There was some huge news out of the PASS Data Community Summit earlier this week as Microsoft announced that paginated reports are now supported with Power BI Pro licences. It feels like this was one of the top requests on the Power BI ideas website for a very long time, Read more…
Greyskull Analytics
Should you hide the filter pane in Power BI?
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…
Power BI
Happy Birthday Premium Per User!
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…
Greyskull Analytics
Don’t fall into this RLS trap!
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…
Power BI
Power BI Calendar Tables: DAX v M
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…
Power BI
To Measure Table or NOT to Measure Table?
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…