Forum Discussion
Copy data from one table to another in Power BI
Hi Experts I have a table in Tab 1 with 20 rows and various columns. I want to copy each day the top ten rows from Tab 1 into Tab 2 a new table... After the data has been sorted and formated. ...
Hi !
Do you want to discard rows from Table 2 each day as well, and load fresh new Top 10 rows from Table 1 daily.
If yes, you can try replicating these step in Power Query (M)
You can use Transform data from Powr BI Desktop, click on Table 1 and select Reference Query transformation, now you can add setp to only keep Top 10 rows from table 1.
Regards,
Hasham
HashamNiaz
Solution Sage
Solution SageHi !
Do you want to discard rows from Table 2 each day as well, and load fresh new Top 10 rows from Table 1 daily.
If yes, you can try replicating these step in Power Query (M)
You can use Transform data from Powr BI Desktop, click on Table 1 and select Reference Query transformation, now you can add setp to only keep Top 10 rows from table 1.
Regards,
Hasham
thanks