View My Drafts
I have a Power BI report with a sales data set that is loaded from Azure SQL database (import) and make visualizations and dashboards.
Now what I want? if I get a new csv file with updated records of sales and can load it from Azure Blob storage
--- Can I integrate the new records into existing power BI report (originally generated from Azure SQL database)
--- if not what is the process to schedule refresh the sales data each day new file was loaded to blob storage with new sales records?
--- and how the scheduled refresh can undergo all data transformations that are saved in Power Query?
Thank you in advance for your help