Can a dataflow be used with virtual tables?

[Syndicate_Admin]

Greetings, all! I need to use the awesomeness of Power Query in a dataflow to transform a series of files but then load the results into an Azure SQL DB. I've recently started checking into creating Virtual Tables with the Virtual Table connector but wanted to see if anyone has experience with/knows if it's possible to use dataflows with virtual tables.

Ideally, I want to be able to (1) create new records, and (2) update existing records if needed.

Do virtual tables support this yet with the recent updates Microsoft announced?

[Syndicate_Admin]

Thanks for the reply, @Syndicate_Admin. My question has more to do with using a virtual table as a Load to existing option. I've successfully set up my virtual table and can see it in the Dataverse:

However, it doesn't show as an option when I try to load to an existing table from a dataflow, which is true of every other Dataverse table:

Any idea what I might need to do to get that to work?

[v-yingjl]

Hi @Syndicate_Admin ,

As far as I know, seems that virtual tables are based on Dataverse which is supported to connect in Dataflows. Perhaps you can try to connect to Dataverse in Dataflows to check it.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.