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
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…
Certification
Power BI Certification – I am now DA-100 Certified!
I’m now a Microsoft Certified Data Analyst Associate