PowerBI.tips

Author: mike carlo

  • 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


  • Monkey Tools are AWESOME

    Monkey Tools are AWESOME

    The Monkey Tools add-in for excel is really amazing. As a developer for Power BI for many years I’ve learn a ton of tips and tricks while working with Power Query. Watching Ken demo the high level of automation that Monkey Tools really blew my mind. How did I not know about this tool earlier?! My development patterns have now forever changed.

    This presentation for Monkey Tools is presented by it’s developer MVP Ken Puls. Ken is a staple and expert in the Excel community. Not to mention, he is an incredible presenter. You will enjoy this session from Ken.

    What are Monkey Tools?

    Monkey tools in short is a simple way to automate data modeling within Excel. There are some incredibly helpful portions such as making date calendars, changing how data is handled during Power Query loading process and many more.

    Ken gives us a great overview and starts digging into the amazing features of this tool in this two part series about this tool.

    Download Monkey Tools Here

    Intro to Monkey Tools – Part 1

    Intro to Monkey Tools – Part 2

    Follow Ken

    Blog: https://xlguru.ca/blog
    Facebook: https://facebook.com/xlguru
    Twitter: https://twitter.com/kpuls
    Linkedin: https://linkedin.com/in/kenpuls

    Training

    Online Training: https://Skillwave.training

    Book by Ken

    Master Your Data with Excel and Power BI: https://amzn.to/2PyheVm
    M is for (Data) Monkey: https://amzn.to/30BElov
    RibbonX: Customizing the Office 2007 Ribbon: https://amzn.to/3fzPDh1

    Download Monkey Tools

    https://xlguru.ca/monkeytools

    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 – July 2020

    Milwaukee Brew City PUG – July 2020

    Welcome to July! This month we have Tommy Puglia from the Chicago Power BI User Group joining us to discuss and talk about driving organizational success with Power BI.

    Tommy is an expert and has spent years deploying Power BI within various organizations. Check out the video below from the July 2020 Milwaukee Brew City Power BI user group.

    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 July 2020

    MVPs React July 2020

    This month we are trying something brand new. We are introducing a new series called MVPs react. As you may already know Power BI has monthly desktop releases. If you are as excited about these releases as I am I love talking about all the new features. So, why not get a fun group of MVPs together to discuss everything.

    These events are similar to a fire side chat about Power BI among the best experts within the community. We hope you enjoy the conversation, and learn a couple new things as well.

    Here is our session for the Power BI desktop release for July 2020.

    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


  • DAX Studio 2.11 Released

    DAX Studio 2.11 Released

    If you haven’t heard about DAX Studio, well now you have. DAX studio is an essential tool for Power BI developers. It enables you to explore and tune your tabular model with ease. This month we are pleased to have the creator of this tool Darren Gosbell present to us the latest updates for DAX Studio.

    DAX Studio has just released it’s latest version 2.11.1.  With this release comes a number of great improvements. 

    New features include

    • Query Builder
    • Query Benchmark
    • More Quick access buttons
    • Exporting button for  trace outputs
    • Tooltips for tabs
    • And many more….

    Watch the Webinar

    Recent Releases

    DAX Studio 2.11.0 Released
    DAX Studio 2.11.1 Release

    Follow Darren
    Website: http://geekswithblogs.net/darrengosbell/Default.aspx
    MVP: https://mvp.microsoft.com/en-us/PublicProfile/35889?fullName=Darren%20Gosbell
    Twitter Handle: @darrengosbell
    Linkedin: https://www.linkedin.com/in/darrengosbell

    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 – June 2020

    Milwaukee Brew City PUG – June 2020

    This month’s Milwaukee Power BI User group we have Reza Rad from Radacad.com. Reza has a long history within the Power BI MVP community. His presentation this month is about how to use dataflows and shared datasets.

    Check out the recorded session below.

    Discounts on Training

    Like Reza’s training, visit the additional learning materials from Reza.
    Use the discount code  “PowerBITips”  to receive a $30 discount on your first month of training.
    Get the training: https://learn.radacad.com/product/academy-membership/

    Download Presentation Slides: https://bit.ly/2YNmBW3

    Follow Reza

    Catch Reza on LinkedIn: https://nz.linkedin.com/in/rezarad
    Visit the website: https://radacad.com/
    Books from Reza: https://radacad.com/ourbooks

    Learn more about dataflows:
    https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-overview
    https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-create-use#creating-a-dataflow

    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


  • Using Lasso with New Shortcuts

    Using Lasso with New Shortcuts

    The April 2020 Power BI desktop release is an amazing release. This month the Power BI team has released a new lasso feature to enable users to select multiple visuals at a time. For me working in reports with lots of strategically placed visuals, this is HUGE!! How many times have I struggled to select a visual. Or, better yet needed to open up the visualization pane to select visuals from a list. The Lasso feature is a very welcome addition to the Power BI toolkit.

    New Shortcuts

    Another interesting feature that I found this month is the ability for Grouping visuals using key commands.

    You can Group Visuals using CTRL + G

    Then you can Un-Group them using SHIFT + CTRL + G

    Like all visual editing programs and even in power point these commands are very common. Thus, seeing these commands in Desktop is amazing. Power BI Team, thanks so much for your wonderful work!!!

    Video Tutorial

    Download PowerBI Desktop

    Want to use these features. Head on over to the PowerBI.com site and download the latest release. Download Here

    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


  • Get to know ALM Toolkit

    Get to know ALM Toolkit

    The ALM Toolkit is an excellent tool for aiding users with Tabular Model management. Christian Wade has been generous enough to provide us with a detailed tutorial on the ALM ToolKit.

    In this webinar Christian Wade takes us on a guided tour of the key features and use cases for ALM ToolKit.

    ALM Toolkit Feature Set

    • Database Compare
    • Code Merging
    • Making Deployment Easy
    • Source-control Integration
    • Reuse of common Definitions

    YouTube Video of 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