
Announcements
Hi,
I am new to Dataflows in Dataverse & Apps. Is the following possible?
1. Run SQL code to pull information from on-premise SQL server (through gateway, etc)
2. Pull data from a Microsoft List
3. Use 1 & 2 to transform data & create new table
4. Saved transformed table into Dataverse table
Thanks for your help!
Hi,
Dataflow can connect to Onpremise SQL using Data gateway. You can connect to multiple source and merge tables.
You can create new Table in Dataverse and do the mapping to load the data to Dataverse.
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-and-use-dataflows
You can use Advanced query in Power Query to run your sql script to pull the data from SQL.
Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/