cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Naresh_Bhagvan Frequent Visitor
Frequent Visitor

Pull Data From D365 FO to Power BI

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.

3 REPLIES 3
Highlighted
Moderator v-yuezhe-msft
Moderator

Re: Pull Data From D365 FO to Power BI

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Naresh_Bhagvan Frequent Visitor
Frequent Visitor

Re: Pull Data From D365 FO to Power BI

@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?

 

 

Moderator v-yuezhe-msft
Moderator

Re: Pull Data From D365 FO to Power BI

@Naresh_Bhagvan,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.