Pull Data From D365 FO to Power BI

[Naresh_Bhagvan]

Hello,

I would like to create reports using data from D365 Production Environment. I created reports in DEV environment using SQL connection, but I am unable to do this for Prod. 

I was able to connect to Prod using Odata feed but it does not give me access to all tables (Ex: SalesTable).

Is there any way to connect to Prod tables directly? or is it possible to migrate reports from test to prod?

Thanks in advance.

[v-yuezhe-msft]

@Naresh_Bhagvan,

Do you connect to Dynamics 365 online for FO in Power BI? If so, it is not possible to connect to the underlying SQL database in Power BI. 

With odata connection, you can never see all your tables, views, only the entities which are made available. For more details, please review this similar thread: https://community.powerbi.com/t5/Desktop/How-to-connect-D365-for-Finance-and-Operations-to-Power-BI-....

Regards,
Lydia

[Naresh_Bhagvan]

@v-yuezhe-msft 

Thanks for the response.

Yes,I have connected to Dynamics 365 FO (test environment) from Power BI desktop using SQL connection which gave access to lot of tables. 

I understand that we cannot connect to Dynamics 365 Production environment using SQL connection, but we can connect using OData feed. My problem is connecting Odata feed does not  give lot of information, so we were not able to cerate same reports that we created in Test Environment.

According to my understandig (correct me if I am wrong), the only way to access more data is to create new Data Entity in test and deploy those data entities into Prod and use this data entities to create reports? or is there any other way to access additional data in Prod?

[v-yuezhe-msft]

@Naresh_Bhagvan,

As per my knowledge,  you would need to create new data entities and add these data entities into Prod.

Regards,
Lydia