Forum Discussion
Post ProdigyInsert row from .csv into new file
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?
3 Replies
- amitchandak
Super User
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-example-is-a-csv-file/
v-xuding-msftCommunity Support
Hi Frixel ,
Is the .csv file your data source? If so, you could configure schedule refresh when you publish the report to service.
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
