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: