DataFlow
Append and Merge to combine data from multiple data source in Power Platform dataflows
Category: DataFlow,Dynamics 365,Microsoft Dynamics 365,PowerApps,PowerPlatform Author: Nishant Rana Date: 4 months ago Comments: 0

Let us continue with our previous post where we loaded the data from on-prem SQL DB to CDS using dataflows. https://nishantrana.me/2020/07/07/load-data-from-sql-on-premise-to-cds-common-data-service-using-power-platform-dataflows-in-power-apps/ Now suppose we have another table (or any other data source) having the contact details, which we would like to append/merge along with our previous data source. For simplicity, here we have created a … Continue reading “Append and Merge to combine data from multiple data source in Power Platform dataflows”
Source: Nishant Rana


Load data from SQL On-Premise to CDS (Common Data Service) using Power Platform dataflows
Category: DataFlow,Dynamics 365,Microsoft Dynamics 365,PowerApps,PowerPlatform Author: Nishant Rana Date: 4 months ago Comments: 0

Let us continue our previous post where we created a connection to the below On-Premise SQL Server Database using an On-premises data gateway. https://nishantrana.me/2020/07/06/configuring-on-premises-data-gateway-to-connect-tosql-server-on-premise-data-source-power-platform/ Here we will use the Power Platform dataflows to load contact entity in CDS using that same on-prem table. Sign in to Power Apps https://make.powerapps.com/home Navigate to Data – Dataflows and … Continue reading “Load data from SQL On-Premise to CDS (Common Data Service) using Power Platform dataflows”
Source: Nishant Rana


Configuring On-Premises data gateway to connect to SQL Server on-premise data source – Power Platform
Category: DataFlow,Dynamics 365,Microsoft Dynamics 365,PowerApps,PowerPlatform Author: Nishant Rana Date: 4 months ago Comments: 0

Let us take a simple example to understand the steps to be performed for configuring an On-premises data gateway. We have below database in our on-premise SQL Server which we connect to using On-Premise data gateway. Below are the steps we need to perform to configure it – Login to Power Apps and navigate to … Continue reading “Configuring On-Premises data gateway to connect to SQL Server on-premise data source – Power Platform”
Source: Nishant Rana