Forum Discussion
multiple csv file as datasource - daily update
Hi everyone, apologies for the subject as I am not sure how to address it. Just wanted to get good advice from pros here.
Scenario: I am receiving multiple CSV files daily as a datasource that needs to update in Power BI. Say for example I will receive Products.csv, Orderdetails.csv, Orders.csv, Customers, Payments.csv on a DAILY basis.
Question: What approach do I have to do in order to make a report that is updated daily based on multiple csvs that I am receiving on a daily basis as well? Appreciated the help 🙂
ronaldbalza2023 , Hope they have old and new data both. Install on premise gateway. and configure schedule refresh after you publish the file to power bis service
Gateway
https://radacad.com/the-power-bi-gateway-all-you-need-to-know
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onpremrefresh
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
1 Reply
ronaldbalza2023 , Hope they have old and new data both. Install on premise gateway. and configure schedule refresh after you publish the file to power bis service
Gateway
https://radacad.com/the-power-bi-gateway-all-you-need-to-know
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onpremrefresh
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh