Which two tools should you use?

A company has an on-premises system that stores product information. The company plans to replace the information with a Power Platform solution that uses the Common Data Service.

The Power Platform solution needs to use data from the product information system.

You need to transform and import the data from the product information system.

Which two tools should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A . Dataflow
B. Business process flow
C. Power BI Desktop
D. Data gateway

View Answer

Answer: A,D

Explanation:

The on-premises data gateway acts as a bridge to provide quick and secure data transfer between onpremises data (data that isn’t in the cloud) and several Microsoft cloud services. These cloud services include Power BI, PowerApps, Power Automate, Azure Analysis Services, and Azure Logic Apps. By using a gateway, organizations can keep databases and other data sources on their on-premises networks, yet securely use that on-premises data in cloud services.

Can use the Power Platform dataflows to load entity in CDS with the option to transform data.

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

https://nishantrana.me/2020/07/07/load-data-from-sql-on-premise-to-cds-common-data-service-using-powerplatform-dataflows-in-power-apps/