Byod integration with d365fo to make powerbi dashboards

 Scenario:- I need to use Byod and send dataset to powerbi and make dashboard for analyzing of data

Step1:-Go to Azure and search for azuresql 

Step2:-Click on azuresql yow will navigate to page shown as below

Step3:-Click on create and fill all necessary details by choosing sql databases then resource group, subscription

and server name ,passwords as shown in image below

Step4:-Once deployment finishes go to resources then in overview page set firewall and allow selected networks

Step5:-Under settings>connections strings copy sql ado.net connector connection string

Step6:-Go to d365fo and open Datamangement choose configure entity export to database

Step7:-create new by giving a new unique name and give connection here and validate .On successful validation you will get a confirmation message

Step8:-click on Publish then you need to choose entity and after publish you will get a confirmation message in notifications as shown in below

Step9:-Enable change tracking for entity you choose for future reference in case you want to do incremental push

Step10:-create a export project and choose your recently published name and add.

Step10:-Export the data project

Step11:-After exporting go to azure sql in azure and open query editor and use a select statement and see data whether exported or not

Step12:-Under Power platform section  choose powerbi and click on login

Step13:-Click on the file it will navigate to powerbi desktop application sign in with credentials

Step14:-Click on connect then dataset will be loaded as shown in below

Step15:-create beautiful dashboards for analyzing data 

Step16:-And I have done a best dashboard previously Titanic disaster as shown in below

Note:-In this way you can convert d365fo tabular data into pictorial representation of data by Powerbi.

Keep Daxing!!