PowerBI.tips

Author: mike carlo

  • 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


  • Mirabile Notitia – Power BI with Harry Potter

    Mirabile Notitia – Power BI with Harry Potter

    I was recently contacted by Power BI Community member Gomathy Viswanathan and Ashwini Nayak. Thus, it is my pleasure share with you their incredible report. The Harry Potter Escape room. If you are as curious as I was you will enjoy this fun and light hearted puzzle.

    Play the Game

    Take a little break today and give the Harry Potter Escape room a try.

    The Creators

    Escape Room, Harry Potter Edition was originally posted on the Power BI Community. Be sure to follow Gomathy and Ashwini on LinkedIn. For a quick tutorial on how to use the game the creators watch the video below.

    Download the Game

    Feel free to download a copy of the Escape Room to see how it was built. While these games are fun to play, there are many techniques you can learn from. Learning the ins and outs of bookmarking definitely will help your report building skills for example.

    Note: definitions for Mirabile Notitia
    Mirable from Mirriam-Webster
    Notitia from Mirriam-Webster

    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


  • Milwaukee Brew City PUG – Oct 2020

    Milwaukee Brew City PUG – Oct 2020

    The Milwaukee Crew is back at it again with the October 2020 Power BI User Group (PUG). This month we have the amazing Gil Raviv talk to us about Power Query and the Enterprise. For those of you who don’t know Gil he is a superb Power Query Expert.

    Gil talks to about Power Query in different enterprise domains. Learn which tools to use and which ones are not quite ready for prime time. You will learn a ton in this great session.

    Watch on YouTube

    Follow Gil

    Be sure to follow Gil Raviv on his website and blog.
    Also I recommend you follow Gil on his LinkedIn page.

    Links Discussed in this Session

    We had many different topics and some links that were shared here are the highlighted links that were discussed in this session.

    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


  • HTML Content Custom Visual

    HTML Content Custom Visual

    Daniel Marsh-Patrick is a custom visual developer who recently released the HTML Content, a custom visual. This month we go over this visual in detail with it’s creator himself.

    While this visual is currently at V1, Daniel shows us a preview of V2 and trust me you will absolutely love it. I’m so looking forward to using this visual in my daily workflow. As well as V2 is going to be amazing.

    Watch the Webinar

    Follow Daniel

    Blog: https://coacervo.co/
    LinkedIn: https://www.linkedin.com/in/daniel-m-p/
    GitHub: https://github.com/dm-p

    If you like Daniel’s work please consider sponsoring him. This way we can continue to get amazing visuals: https://github.com/sponsors/dm-p

    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


  • MVPs React October 2020

    MVPs React October 2020

    Horary! The Power BI desktop for October finally arrived and it is packed with tons of updates. I’m super excited about this month’s release. We rallied the troops and have a ton of MVPs talking about the latest release of Power BI desktop

    Microsoft Blog Post

    Click the link to the official Microsoft blog post.

    Watch MVPs React

    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


  • Customize the Default Dataset

    Customize the Default Dataset

    In the October 2020 release of Power BI desktop you have the ability to load a dataset from the splash page. For this tutorial we dig in on how Microsoft enables a default dataset. Additionally we show you how to customize the default dataset for your needs.

    Quite often I need to prototype a visual, or work on some sample data to design a report. The very first step is always loading some sample data. Now that Power BI desktop comes with a default dataset, we leverage this feature to speed up our development process.

    Watch the YouTube Video

    Additional Thoughts

    In this video I explain that the dataset does not auto load with datatypes enabled. This was due to my default setting within Power BI desktop. If you’d like you can make Power BI Desktop auto detect your datatypes for you.

    This setting can be changed by the following steps:

    • Click on the File button
    • In the drop down menu, Click on the Options and Settings
    • In the menu on the right Click the button labeled Options
    • Under the Global section in the Options menu Select the item labeled Data Load
    • Change the Type Detection for loading data

    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 Quiz – Themes

    Power BI Quiz – Themes

    This month I had the privilege of participating in the Power BI Quiz. If you don’t know about the Power BI Quiz show, this is an event that is put on by Just Blindbaek. Just does a great job of creating a Season of Quizzes. Experts from across the Power BI community are co-hosts and submit questions about a specific topic.

    This week the topic was all about themes. Thus, I whipped up some questions and had an absolute blast!

    Thank you to everyone who was able to participate and play the game.

    Full Episode

    Play the Game

    If you’d like to play the game with your team or just for fun here is the official link.

    Next Game

    If you like this video and would like to participate you have one more chance for season 2.

    Next up will be the Christian Wade from the Microsoft Power BI team discussion the Semantic Models.

    Join the Live stream with Christian Wade and Just Blindbaek on 10/21/2020 at 1 PM CDT

    Be sure to subscribe to Just’s channel on YouTube if you enjoy his content.

    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


  • MVPs React September 2020

    MVPs React September 2020

    This month we got the Power BI desktop update a little bit later because it was released during the 2020 Ignite conference. As always the MVPs are super excited to talk about the latest Power BI features.

    This month’s release was packed with all sorts of new features. For a full list of features read the official Microsoft Blog post. Some of our favorite features that the MVPs talked about are:

    • Search for a workspace during publishing
    • Premium Per User (PPU)
    • Maintain Visual Layer Order
    • Databricks Connector
    • New Icon

    Watch the Full video

    MVPs attending this event

    Alice Drummond – https://www.discoverei.com/

    Benni De Jagere – https://www.linkedin.com/in/bennidejagere

    Daniel Marsh-Patrick – https://www.linkedin.com/in/daniel-m-p/

    Marc Lelijveld – https://data-marc.com/

    Reid Havens – https://www.havensconsulting.net/

    Seth Bauer – https://powerbi.tips/author/sbauer/

    Mike Carlo – https://powerbi.tips/author/mike-carlo/

    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


  • Milwaukee Brew City PUG – August 2020

    Milwaukee Brew City PUG – August 2020

    Back again with another Power BI User group for Milwaukee. This month Mike and Seth walk through the beta release of external tools. If you didn’t see the announcement from Microsoft but in July of 2020 was the release of External tools.

    What are External Tools? I’m glad you asked. An External Tool is an application that can be used along side with Power BI. Parameters can be passed from Power BI desktop into the External Tool, such as a connection string to the data model.

    We are super thrilled about this new ability to enhance the Power BI desktop experience so much that we built a custom installer that will enable users install many of these external tools all in one place. This is why we build Business Ops.

    Watch this month’s PUG to see how to install External Tools for your machine.

    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