Reporting with on-premise data sources

Our first Power BI report will use the on-premise World Wide Importers we talked about earlier in this book. We will first connect to the World Wide Importers relational database using Power BI for desktop.

If you haven't created an account yet, create one now; it's free. If you already have a Power BI account, select the link as highlighted in the following screenshot:

Once connected, uncheck Show this screen on startup and click on the Get data.

In the Get Data window, select SQL Server database and click on Connect:

As shown in the following screenshot, enter the local on-premise server name and choose ...

Get Hands-On Data Warehousing with Azure Data Factory 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.