Defining the data source

For a fresh start, our journey will begin with the Get Data link on the upper-left part of the welcome screen. You'll be presented with a dialog window with a large variety of available data sources, which you can add to your Power BI model. Based on the available data, we can then create the Power BI Report, which is a set of visual components and their interactions.

As you can see on the dialog, even if you filter out just the Database type of data sources, there's still a plenty of choices for you. The first one listed is the SQL Server database. This one expects a SQL Server to be running locally. If you have ...

Get Hands-On Data Science with SQL Server 2017 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.