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.
Power BI
The “Unknown Date” Dilemma
Welcome to my brain. This is a peek into the way it ticks, and the fact that this particularly random issue popped in to my head at 3am and then proceeded to keep me awake for the rest of the night. The issue in question: what’s the best way to Read more…
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…
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…
Measure Tables
Another advantage to Measure Tables
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…
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
Creating Date and/or Time Tables with SQL
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…
Greyskull Analytics
Why I LOVE SQLBits
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…