Introducing the Measure Killer (External Tool) for Power BI!

Подписаться 30 тыс.

Просмотров 5 тыс.

50% 1

Learn about an up and coming external tool that makes it easy to identify and KILL unused measures and columns from a Power BI dataset (PBIX). Gregor Brunner will walk us through how to use this great tool, how it works, and more. Tune in to find out!
GUEST BIO 👤
Gregor Brunner is 34 years old, has a background in Economics but moved into Business Intelligence in 2016. Originally from Austria, he moved to Switzerland in 2020 and started Brunner BI, a boutique IT company that specializes in Microsoft Power BI development and consulting.
RELATED CONTENT 🔗
Measure Killer (Site) - en.brunner.bi/measurekiller
Measure Killer (Microsoft Store) - apps.microsoft.com/store/deta...
Website - www.brunner.bi/
BECOME A CHANNEL MEMBER 🎉
-- / @havensconsulting
CHECK OUT OUR MERCH STORE 👕
-- havens-consulting.creator-spr...
LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
-- / havensconsulting
HAVENS CONSULTING PAGES 📄
Home Page - www.havensconsulting.net
Blog -- www.havensconsulting.net/blog-...
Blog Files -- www.havensconsulting.net/blog-...
Files & Templates -- www.havensconsulting.net/files...
Consulting Services -- www.havensconsulting.net/consu...
Online Courses -- www.havensconsulting.net/onli...
Contact & Support - www.havensconsulting.net/conta...
EMAIL US AT 📧
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #measurekiller #externaltools

Наука

Опубликовано:

23 окт 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 24

@terpstry Год назад

Tools like these, and there are not so many, can be very valuable. Having a lean & clean model is important in many ways, no discussion on that. When you have control over your datasources making use of RemoveColumns is maybe not so bad but when you don't it is a thing to consider. Any changes to your datasource like columns being removed will result in an error when the model gets refreshed. Nevertheless, the potential value of MeasureKiller is huge.

@noahhadro8213 Год назад

Yes I would buy that tool if something could help identify unused columns across a live dataset used by multiple reports! When I started watching this I was optimistic that this was the tool. Very Cool tool but bummed it won’t work with thin reports.

@MeasureKiller Год назад

we are working on it ;)

@noahhadro8213 Год назад

@@MeasureKiller Fantastic! Where is the best place to stay up to date so that I can know when this is released. Thanks for the great work!!!!

@pgrealestate2005 Год назад

It's so clean, great tool. Thanks that the free version actually helps. though I don't think the tool recognizes when a column is used to order an other column ex index columns.

@MeasureKiller Год назад

Thanks for your feedback! Do you mean ‚sort by‘ another column? Not sure exactly what you are referring to.

@PedroCabraldaCamara Год назад

Great tool! But to be an awesome tool, I think I would add the information about the folder and subfolders where they're saved, and also, the table and columns names of those measures. Great job guys

@HavensConsulting Год назад

Same! Hopefully that comes out some day

@andrewsliu Год назад

I have a base dataset that has multiple reports using it Would be great if the tool can load multiple related reports and scan all of them together to find unused measures/columns.

@HavensConsulting Год назад

If anyone could make something to scan these it would be a GAME CHANGER. However I think it would only work with premium where it can use the SMLA endpoint :\ Otherwise Microsoft would need to do this

@MeasureKiller Год назад

Measure Killer can already do this in its current version

@andrewsliu Год назад

@@MeasureKiller I'll have to check it out then!

@Negi_From_Pauri Год назад

Hey pal i am big fan of yours, "POWER BI"☺ i have a question about power query we can undo(means delete) the step, So is there any way we can redu(means to get last deleted step) the step deleted step could be in any line in applied steps. I am asking because sometimes the step is big we write m query so that we just can redu the step instead of to write m query again.

@HavensConsulting Год назад

Sadly no undo or control Z in Power Query! My best practice is to duplicate the query and make changes there, saving your original query. When you're done then copy/paste the advanced editor code back into the original one! I wished there was an easier way, but I've also made the mistake of accidentally deleting an applied step!

@MANATTOWN Год назад

Can we use this on ssas

@HavensConsulting Год назад

I don't think so today! Looking at the tool it appears to only connect to local models open on your machine.

@MeasureKiller Год назад

Correct!

@jazriopk Год назад

Super!! How can you identify what to kill in your model if all your reports read from PBI service a central data model which contains all the measures?

@MeasureKiller Год назад

Currently we can only analyze single reports!

@HavensConsulting Год назад

@@jazriopk we talk about that limitation towards the mid to end of the video as well. Not really possible to check with multiple reports connected to one model today. :\

@In_a_state Год назад

I'm afraid this has too many false positives, it's not usable.

@MeasureKiller Год назад

Can you show me where this is happening? we are always looking to improve our tool!

@In_a_state Год назад

@@MeasureKiller this seems to occur when there are certain degrees of dependencies between measures.

@MeasureKiller Год назад

If a measure is only used in another measure it should find it without any problems. If you can give me a concrete example I can take a look though, thanks!