Copy data from one table to another in Power BI

[Anonymous]

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.

Is this possible in Power BI.

[HashamNiaz · Accepted solution]

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

[Anonymous]

thanks