how to check a dataflow is writing to which dataverse table

(0) Share

Report

Posted on by hongkong

277

I have setup 3 dataflows to read data from adls gen2 to dataverse table. The dataflows are refreshing successfully.

However I am not sure which table is created by which dataflow.

Because I am doing tests, all the sources are named as "Test123". I can find a table "Test123" in dataverse but I can only find ONE Test123 table while I have 3 different dataflows.

Is there anyway to verify how the dataflow is writing to?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

AhmedSalih 6,678 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello, @hongkong, Dataflows load data into existing tables or new tables. If you set it to create new table the first time you publish, it will create one table. Once you set it to automatically refresh, it will load the data to the same table that was created the first time, it won't create new table.

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: ahmedsalih.blog

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

Microsoft Business Application MVP

Was this reply helpful? Yes No
Shashank Bhide 944 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you edit your dataflow? I guess that can tell you where your data is going

Was this reply helpful? Yes No
hongkong 277 on at

Like (0)

Report
Copy link

Link copied!

When you choose create a new table, it will not tell you the destination table information. According to my test, it will create a table with same name as your query's name. However I am not sure what will dataflow do when multiple query are using the same name.

Was this reply helpful? Yes No
hongkong 277 on at

Like (1)

Report
Copy link

Link copied!

When you edit the dataflow, it will let you update the Power Query only. You can change the query name or code. Nothing about the destination table.

Was this reply helpful? Yes No