Integrating Excel with Power BI

In this recipe, we will continue from the last recipe and create a dashboard by using this data model. Use this excel file as a data source to build your Power BI tile.

How to do it...

1. Log in to http://app.powerbi.com using your organization credentials. For first time users, you can sign up for a trial version:

2. Create a new dashboard by clicking on the plus sign (+) next to Dashboards. Enter the name as vendor payment.
3. Click on GetData and under the Files tile click on select Local File and load your excel file and then import it into Power BI:

4. On successful import your dashboard should look like this:

Save your setup.

5. Now you will be able to use this Power BI tile in Dynamics 365...