Using Finance and Operations, Business edition as Power BI Data Source for Building Reports

You can make your Finance and Operations, Business edition data available as a data source in Power BI and build powerful reports of the state of your business.

Note

You must have a valid account with Finance and Operations, Business edition and with Power BI. Also, you must download Power BI Desktop.

To add Finance and Operations, Business edition as a data source in Power BI Desktop

  1. In Power BI Desktop, in the left navigation pane, choose Get Data.
  2. In the Get Data window, choose Online Services, choose Dynamics 365 for Finance and Operations, Business edition, and then choose the Connect button.
  3. Power BI displays a wizard that will guide you through the connection process. The first step will be to sign into the service. Select Sign in and choose the account you would like to sign in as. This should be the same account you sign into Finance and Operations, Business edition with.
  4. Choose the Connect button to continue. The Power BI wizard shows a list of Finance and Operations, Business edition companies and data sources. These data source represent all the web services that you have published from each company in Finance and Operations, Business edition.
  5. Alternatively, create a new web service URL in Finance and Operations, Business edition by using the Create Data Set action in the Web Services page, using the Set Up Reporting Assisted Setup guide, or by choosing the Edit in Excel action in any lists.
  6. Specify the data you want to add to your data model, and then choose the Load button.
  7. Repeat the previous steps to add additional Finance and Operations, Business edition data to your Power BI data model.

Note

Once you have successfully connected to Finance and Operations, Business edition, you will not be prompted again to sign in.

Once the data is loaded it will appear in the right navigation on the page. At this point, you have successfully connected to your Finance and Operations, Business edition data and are ready to begin building your Power BI report. For more information, see the Power BI documentation.

See Also

Business Intelligence
Welcome to Dynamics 365 for Finance and Operations, Business edition
Importing Business Data from Other Finance Systems
Setting Up Finance and Operations, Business edition
Finance
Connecting Power BI to Finance and Operations, Business edition