Microsoft ships pre-built Dynamics 365 for Operation content packs for Power BI, which includes dashboards and reports. For demonstration purposes we could also load these content packs from PowerBI.com in our application and analyze the data.
In this recipe, we will show you how to develop a Power BI dashboard for organizational content packs, to share their data and datasets, reports, and other visual analytical data within their organization.
- Get Power BI desktop to connect your Azure SQL database from this link: https://www.microsoft.com/en-us/download/details.aspx?id=45331.
- After installation, open Power BI Desktop and select the
Get Data
option, as shown in the following screenshot:
- Here we get various options for our data source. We could choose any of the options here, but for this recipe we will choose SQL Server:
- Fill in the details as shown in the preceding screenshot and click
OK
to connect.
- Select the two tables,
InventSum
andInventDim...