RE: Dyanmics general idea of connecting four different things.
Hi EmployeeOcta,
Currently PowerBI could only get data from following D365 Customer Engagement content packs:
[View:https://docs.microsoft.com/en-us/dynamics365/customer-engagement/admin/use-power-bi#get-started-using-power-bi-with-dynamics-365-for-customer-engagement-apps-online:750:50]
Sales Analytics for Dynamics Customer Service Analytics for Dynamics 365
Microsoft Dynamics 365 - Social Engagement
While MS still provides some applications or Solution Template to integrate FS and PSA
PBI with Field Service: [View:https://powerbi.microsoft.com/en-us/partner-showcase/journeyteam-power-bi-analytic-solution-for-dynamics-365-for-field-services/:750:50]
PBI with PSA:[View:https://community.dynamics.com/365/projectserviceautomation/b/daytodaydynamics365/archive/2017/10/23/dynamics-365-project-service-automation-analytics-extending-psa-39-s-reporting-with-the-power-bi-solution-template:750:50]
PBI with F&O: [View:https://www.powerobjects.com/blog/2018/06/25/how-to-integrate-power-bi-with-dynamics-365-for-finance-and-operations/:750:50]
I would recommend CDS for data integration if your want to integrate D365 Internal Apps like Field Service, PSA and Financials.
Integrate data into Common Data Service: https://docs.microsoft.com/en-us/power-platform/admin/data-integrator
Extensible Data integrator templates and the Common Data Service (CDS) to integrate FS with D365: [View:https://docs.microsoft.com/en-us/dynamics365/unified-operations/supply-chain/sales-marketing/field-service:750:50]
Finance and Operations and PSA via CDS:
https://docs.microsoft.com/en-us/dynamics365/unified-operations/financials/project-management/psa-integration
https://docs.microsoft.com/en-us/business-applications-release-notes/april18/dynamics365-finance-operations/integration-dynamics365-project-service-automation
Regards
Johnny