Insert row from .csv into new file

[Frixel]

Hi all,

Is there a possibility to get the last line from a newly created .csv file and have it inserted in an existing (master) file?

[v-xuding-msft]

Hi @Frixel ,

Is the .csv file your data source? If so, you could configure schedule refresh when you publish the report to service.

Configure scheduled refresh 

If we misunderstand, please share more details with us. Thanks.

[Frixel]

@v-xuding-msft 
@amitchandak  I have not an Azure SQL Serverless DB(knowledge) like the link you send.

Yes the .csv is the source on OneDrive.

I have there also a masterfile where the last row must be set in.

The last row is always te row with the most recent date and time in the .csv 

[amitchandak]

@Frixel , is there a way to know last line.

refer this blog can help https://www.fourmoo.com/2020/06/10/how-you-can-incrementally-refresh-any-power-bi-data-source-this-e...