PowerBI.tips

Month: November 2020

  • Building a Power BI Admin View using Power BI APIs

    Building a Power BI Admin View using Power BI APIs

    We just completed an amazing webinar from Parker Stevens over at https://bielite.com/ . In this webinar, Parker walks us through how to connect to the Power BI Admin APIs. The Admin API contains a wealth of knowledge for all activity within your Power BI tenant.

    While there is a good amount of reporting built into the Power BI admin page, you may need more. This is why you would use the Admin APIs to gather all the activity data from within your Power BI. For more information, learn about the Power BI Admin Portal.

    Parker takes us through a deep dive connecting to the Power BI admin apis and shows us how to build a robust dataset ready for Admins to produce the reporting they need.

    Watch the Full Webinar

    If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials.  Subscribe to our YouTube Channel.  Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.

    Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:

    Check out the new Merch!

    Hasta La Vista Data
    Go Ahead Make My Data
    PBIX Hat


  • Power BI Field Finder V2

    Power BI Field Finder V2

    The Power BI Field Finder created by Stephanie Bruno was just updated. In this recent update the HTML viewer has been updated since the old custom visual has been deprecated.

    What is Field Finder?

    We are glad you asked. The Power BI Field finder is a tool that can be used to review all the relevant connections between tables, measures and visuals within a report. This solution is easy to use and very informative. Simply point the Field Finder at a PBIX file. Then the Field Finder tool will de-construct all the visual elements of the report and digest them in to one complete data set.

    Why do I need it?

    If you have done any Power BI development over the years, you will notice a pattern.

    • Start building a report
    • Create some measures for a visual
    • Measures don’t work or report needs changes
    • Make more measures
    • Delete and replace visuals
    • Add visual styles and elements requiring additional measures
    • Finally publish report

    After completing this process, which could be over the span of days to months. You will likely have a Power BI report with extra measures or un-needed calculated columns.

    Then you are introduced with a problem, How do I go through and clean up the entire report? Do I need to click on every single visual to see which measures are used?

    Doing this for a page or two you quickly are overwhelmed with tracking all that information. This is where Power BI Field Finder really shines. It handles all of that for you with a couple button clicks.

    Download Power BI Field Finder

    Be sure to download field finder for yourself.

    If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials.  Subscribe to our YouTube Channel.  Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.

    Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:

    Check out the new Merch!

    Hasta La Vista Data
    Go Ahead Make My Data
    PBIX Hat