Need help to use csv file for real time dashboard in Power BI Premium

[Anonymous]

Hello,   We have a csv file that gets updated every 5 minutes to show the real time data from our SQL server. We want to create a dashboard in Power BI PRO that updates as the csv file updates. Can you please guide us on how to do this? We are currently on Power BI Premium but we are not allowed to set a gateway due to security.  

Thank you,   Mildred   

[Anonymous]

Have you checked wether you can do this using Power Automate? If the csv is located in Sharepoint, you might be able to create a flow that updates your dataset as your Sharepoint file is updated.

https://flow.microsoft.com/nb-no/galleries/public/templates/78375cfc773e45c1b9f87d14de7d7f37/update-...

[v-lid-msft]

Hi @Anonymous ,

If you want a real-time dashboard, we suggest to develop an application which can read the update part of this csv file and push the new rows into a streaming dataset every five minutes.

Best regards,