Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have recently created a dataflow, I did not want to bring every table across from my SQL source as there was hundreds.
What is the easiest way to be able to add another table in from the same datasource already generating the other tables?
I was worried adding the same SQL datasource again would duplicate the datasources? i ideally want to be able to go back to the navigator and select another couple of tables on top of the ones I have, is anything like that possible?
Solved! Go to Solution.
You wanted to add another table in same Dataflow, below are 3 easy steps
1. Copy paste existing table
2. Delete all the steps after navigation
3. change the table name in navigation step
Adding new table will not duplicate your data source.
If this post helps, then please consider Accept it as the solution and give it a thumbs up
Hi @MYVFD ,
Reconnect the sql source and select the table you need:
Below is a reference if needed.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
You wanted to add another table in same Dataflow, below are 3 easy steps
1. Copy paste existing table
2. Delete all the steps after navigation
3. change the table name in navigation step
Adding new table will not duplicate your data source.
If this post helps, then please consider Accept it as the solution and give it a thumbs up
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.