Forum Discussion
Missing New Tables in Data Warehouse
Hi All. I have a data flow that is connected to a data warehouse. I recently added some tables to the dataflow, but those new tables are not showing up in my data warehouse. I can't find were to edit the connection settings to include the new tables. The Get Data options only create new connections, not allow me to edit the current connection. From reading, it seems like the new tables should appear automatically. I'd rather not have to create a new connection because I don't want to have to recreate all the views that are in the data warehouse. Any help would be much appreciated!
Hi jlpdx24 ,
Based on your description, first of all are you using Dataflow Gen1 or Dataflow Gen2. If you are using Dataflow Gen2, you can specify the data target for each query individually, and you can either create a new table or pick an existing table when loading into the data target. However, you need to be aware that there are two options for creating a new table and for an existing table, if you choose to create a new table, then when you choose to create a new table, a new table will be created in the data target during the Dataflow Gen2 refresh. If you select Existing Table, then the update will be done in the current existing table.
Dataflow Gen2 data destinations and managed settings - Microsoft Fabric | Microsoft Learn
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
4 Replies
I posted this in Power Query but it is probably more appropriate here:
I have a data flow (pulling from a SQL DB) that is connected to a data warehouse. I recently added some tables to the dataflow, but those new tables are not showing up in my data warehouse. I can't find were to edit the connection settings to include the new tables. The Get Data options only create new connections, not allow me to edit the current connection. From reading, it seems like the new tables should appear automatically. I'd rather not have to create a new connection because I don't want to have to recreate all the views that are in the data warehouse. Any help would be much appreciated!
jlpdx24 I seem to remember having similar problems trying to mesh dataflows with data warehouse. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".I was hoping I was just missing something! Bummer. I'll submit a support ticket. In the meantime, is my only option to create a new data source (a data flow) and replace the current one? Is there a better way to do this?
Hi jlpdx24 ,
Based on your description, first of all are you using Dataflow Gen1 or Dataflow Gen2. If you are using Dataflow Gen2, you can specify the data target for each query individually, and you can either create a new table or pick an existing table when loading into the data target. However, you need to be aware that there are two options for creating a new table and for an existing table, if you choose to create a new table, then when you choose to create a new table, a new table will be created in the data target during the Dataflow Gen2 refresh. If you select Existing Table, then the update will be done in the current existing table.
Dataflow Gen2 data destinations and managed settings - Microsoft Fabric | Microsoft Learn
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
