Suggest me the way to use Direct query in better way

[Ganesh31]

Hi Experts,

I created a dashboard with source as MS sql (direct query) , but now the new data is comming in the form of csv, in that csv file daily new data gets append. now i want to ingest that new data into mssql daily automatically. suggest me to do this task effectively. Thanks   

[amitchandak]

@Ganesh31 , You have to use power automate or write some code in python/java to append that.

Database also provide feature to read file, you can read and append , you can have sql procedure for that