Forum Discussion
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-with/m-p/276830#M8297.
Regards,
Lydia
Anonymous
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?
Naresh_Bhagvan,
As per my knowledge, you would need to create new data entities and add these data entities into Prod.
Regards,
Lydia