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 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: