The Power BI Designer and Power BI for Office 365 contain a variety of different data source connectors that we can use to access the data of ERP. A few of these options are:
SQL Server
ODBC
SSAS Connector for Dynamics GP Analysis Cubes
In this chapter, we will use the connector for SQL Server, which is a deployed instance of SQL Server databases for the Dynamics GP sample company database. If you do not have access to a Dynamics GP instance, download and import the sample TWO.mdf
database file from the following link (https://www.dropbox.com/s/e3ohgpz8agtxc7h/TWO.mdf?dl=0). If you have Dynamics GP installed with the sample company, use the TWO
database.
Tip
To download a trail version of the latest version of SQL Server, refer to http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2014.