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,
We've been trying to find a way to load a source from MSSQL once. And then work with this query as a datasource within the Power BI model. We want to re-use the already imported source data from MSSQL. So we have a table and want to duplicate that table and then transform this second table. The transform action is used to unpivot some data in the source table, but we want to keep this source table intact and execute the transform action on a derived table.
Is this something that can be done in Power Query? So you can create a new table of an existing table and use that in your models tab.
Or do we have to do this a completely other way. If there is a videoclip or article explaining this, that would be a big help.
Thanks
Solved! Go to Solution.
@vvanasperen , Right-click, and duplicate.
Few methods
https://backtosql.wordpress.com/2019/04/19/the-easy-way-to-duplicate-tables-in-power-bi/
@vvanasperen , Right-click, and duplicate.
Few methods
https://backtosql.wordpress.com/2019/04/19/the-easy-way-to-duplicate-tables-in-power-bi/
So just to be sure, if you duplicate a source table it only executes the query once?
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.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |