Power BI connection to Microsoft D365 FO

Download the Power BI desktop application. Link

Install the application and run it.

Sign in with your Microsoft account.

Step 3. Connection to the database

• URL Based connection

• SQL server connection

URL Based connection

You can connect to D365 server URL directly.

Copy the URL and add data at the end. Enter the client credentials and you will get the connection. 

• SQL server connection

Login to LCS and get the AX DB details like. 

Server name: spartan-***-****-d365***prod-**********.database.windows.net

Database name: db_d365***prod_********_********_****

Username: axdbadmin

Password: ***************