Customize the Default Dataset

October 22, 2020 By Mike Carlo

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

May 15, 2026

Importance of Skills for the Fabric Developer - Ep.528

In this episode, Mike and Tommy dig into why building the right skills matters for Fabric developers and how that thinking changes what you learn first. They also discuss how to evaluate skill depth, avoid tool-chasing, and create a plan for steady growth.

May 13, 2026

Semantics Layer Genie & Data Agents - Ep.527

Mike and Tommy explore what ‘semantic layer genies’ and data agents could mean for Fabric and Power BI teams, from metadata-driven modeling to assisted development workflows. They break down where agents help today, what needs governance, and how to stay practical as the hype accelerates.

May 8, 2026

Stop Using Bookmarks - Ep.526 - Power BI tips

In Episode 526 of Explicit Measures, Mike Carlo and Tommy Puglia unpack the latest Power BI and Microsoft Fabric topics from the show. You’ll get a quick read on the episode’s biggest ideas, why they matter, and where to dig deeper in the full conversation.