PowerBI.tips

Tag: datasets

  • 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


  • 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