Best Practice Analyzer in Tabular Editor for your Power BI Dataset

Поділитися
Вставка
  • Опубліковано 17 лют 2021
  • Do you work on your Power BI dataset or data model? Are you following best practices? Patrick walks you through a best practice analyzer set for Tabular Editor, from Michael Kolvasky, that can help you improve your data model.
    Blog post: powerbi.microsoft.com/blog/be...
    Tabular Editor: tabulareditor.com/
    Download BPA Rules: github.com/microsoft/Analysis...
    Michael Kolvasky's Blog: www.elegantbi.com/
    Feedback: pbibestpractice@microsoft.com
    📢 Become a member: guyinacu.be/membership
    *******************
    Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
    🎓 Guy in a Cube courses: guyinacu.be/courses
    *******************
    LET'S CONNECT!
    *******************
    -- / guyinacube
    -- / awsaxton
    -- / patrickdba
    -- / guyinacube
    -- / guyinacube
    -- guyinacube.com
    **Gear**
    🛠 Check out my Tools page - guyinacube.com/tools/
    #PowerBI #TabularEditor #GuyInACube
  • Наука та технологія

КОМЕНТАРІ • 29

  • @seamushand8439
    @seamushand8439 Рік тому +1

    Very useful tool both to fix issues and to improve how to build models. Thank you.

  • @tomaskavicky
    @tomaskavicky 3 роки тому

    for sure, thanks Patrick. A new level !

  • @caronturner8009
    @caronturner8009 3 роки тому

    Brilliant. Thanks Patrick.

  • @billcoleman2009
    @billcoleman2009 3 роки тому

    Gold! Thanks Patrick

  • @mimimoo4493
    @mimimoo4493 5 місяців тому

    this channel has done wonders to everything I do in PBI. Thanks!

  • @KerryKolosko
    @KerryKolosko 3 роки тому

    Mind Blown 🌬️

  • @qubedcorp7340
    @qubedcorp7340 3 роки тому +6

    Holy Cow... That is bananas.... Exactly the kind of tool and smooth overview I was seeking. The implementation is superb, and the highlight reel (this video) is sublime (as usual). The two together are a powerful productivity boosting combination. You guyz r da bomb.

  • @curiouspie1264
    @curiouspie1264 2 роки тому

    Amazing. Thanks for yet another helpful video guide.

  • @andrewvasiliou
    @andrewvasiliou 3 роки тому +5

    Awesome job, was playing around with it and noticed you also need to have 'Allow unsupported Power BI features' tickbox in Preferences checked to ensure the apply fix scripts will work, for me this was unticked by default.

  • @jorgeeduardomoltenimoreno3048
    @jorgeeduardomoltenimoreno3048 3 роки тому +1

    AMAZING! THANKS

  • @ivyg9827
    @ivyg9827 3 роки тому

    SUPERB! THANK YOU SO MUCH!

  • @PranayPawar1991
    @PranayPawar1991 3 роки тому

    What a great work 🙏👍

  • @davidroberto3533
    @davidroberto3533 3 роки тому

    Amazing job !!!!

  • @seanvsn
    @seanvsn 2 роки тому

    Great stuff Guy, thanks, this was really helpful

  • @raulcadenas7999
    @raulcadenas7999 3 роки тому

    Thanks a lot!! Very useful (as always).

  • @papymusso
    @papymusso 3 роки тому

    Amazing ! Thanks a lots !

  • @ConcordHk
    @ConcordHk 3 роки тому

    Great job ! :)

  • @chango33rd1
    @chango33rd1 3 роки тому

    Love the video! Thanks to you and Adam for putting these videos out to help us out. I did have a question. I'm working on a Dashboard that has, at last count 45 visuals! I ran the performance analyzer and my "Query Ms" times aren't huge (worst one was 135 Ms) but 13 of the "Render Ms" are above 5000! Do you know if just the sheer volume of visuals that is causing this? I also noticed when we run this report in the Edge browser it runs extremely slow but when we run in chrome it runs a lot faster. Thanks

  • @andyl7775
    @andyl7775 3 роки тому

    Really great tool. Anyone know off-hand why 'Apply fix' does nothing for me?

  • @venkateshns2003
    @venkateshns2003 3 роки тому

    I am using this calculation group. this is very helpful. I am facing a problem when i export it from power bi service. the problem is - I see the measures like CY,PY,YoY,YoY% CY reach% to PY in columns in the visuals, but when i export this to an excel then these measures are not exported as columns but they are turned into rows and also changes the number formats from %s to numbers. Can you please let me know if you have a solution for this?

  • @pakistantourneys2023
    @pakistantourneys2023 Рік тому

    Can anyone help me understand how to enable the generate fix for my data model? I cannot find any blog post about it. i have a lot of errors and i dont want to manually go through them if the generate fix script can help me clean it! Please help :')

  • @mattorange
    @mattorange 3 роки тому +2

    Wow. I'd like to understand all the functions that slow down reports. Maybe go through that JSON file. I'm sure I'm committing a lot of these "slowing" errors at work. Are there any videos on functions to avoid, due to inefficiencies on this channel?

    • @alexisjorge3044
      @alexisjorge3044 2 роки тому

      I know I am quite randomly asking but do anyone know a good place to stream new tv shows online?

    • @jordanwillie6726
      @jordanwillie6726 2 роки тому

      @Alexis Jorge flixportal :P

    • @alexisjorge3044
      @alexisjorge3044 2 роки тому

      @Jordan Willie Thank you, I went there and it seems like a nice service =) I really appreciate it !!

    • @jordanwillie6726
      @jordanwillie6726 2 роки тому

      @Alexis Jorge You are welcome =)

  • @lravikiran88
    @lravikiran88 11 місяців тому +1

    Microsoft supporting Third party tools LOL