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

Jun 10, 2026

You Are Wasting Your Time! – Ep.531

Stop wasting time in Fabric by identifying inefficient workflows and adopting better practices. Mike and Tommy discuss OneLake storage reporting, Fabric Jumpstart accelerators, and practical ways to speed up your Fabric development.

May 22, 2026

Agentic Skill & Report Design – Ep. 530

Episode 530 explores how agentic coding is reshaping report development, from faster prototyping to new expectations for model and visual design. Mike and Tommy connect the May 2026 Power BI updates to a practical question: which skills still matter most when AI builds more of the stack.

May 20, 2026

AI Driving Your CoE - Ep.529

AI can strengthen a Center of Excellence, but only when it is applied to clear business goals, known pain points, and a defined maturity baseline. Mike and Tommy explain where AI can genuinely reduce friction, where it creates noise, and how teams can prove it is making the COE better rather than just bigger.