Step 4 - Load Product Table to PowerBI

Created by: Kristinn Magnusson

Modified on: Mon, 6 Jan, 2020 at 6:43 PM

Data can be loaded to others Data & Analytical tools via SQL or ODBC driver.

Load Data into PowerBI

Open PowerBI and click on Get Data > SQL Server database and Connect

Type in the Server (default is mp77op1ebc.database.windows.net) and Database Name and click OK

Filter on data.Product in the Search Box, Click on the Checkbox next to data.Product and click Load

Model should now be loaded. Click on Sell Start Date and drag Product ID to Value you should see the following chart:

Click on the canvas and click on Color and drag Product ID to Value. Now we have a dashboard where we can drill down to the Product Master. We can see that there are 20 Products that are Black and started selling in 2013:

Kristinn is the author of this solution article.

Did you find it helpful? Yes No

Step 4 - Load Product Table to PowerBI

Load Data into PowerBI

Related Articles