Forum Discussion
Automatic update at least every hour with editing in Power Bi Desktop before
lukas1,
"But if I get this right, in this case it is only possible to update through scheduled refresh (which is only possible 8 times a day)?"
In this case, when you change data in Excel source file, you are only able to set schedule refresh for your dataset to bring changes to Power BI Report. Unless you have Power BI premium license, you will be limited to refresh 8 times a day.
"Do you think to build up a SQL database would be the easiest way to achieve the automatic updates?"
Yes. you can use DirectQuery mode to connect to SQL database and achieve hourly refresh in Power BI Service.
Regards,
Lydia
Anonymous Thank you very much for your answer!
Yes, I would need to take the second path you described, where I use Power BI desktop (to add measures, etc.) before the Power BI Service. But if I get this right, in this case it is only possible to update through scheduled refresh (which is only possible 8 times a day)?
But it would be possible with an SQL Database. Thank you very much for this Idea. Right now I only have a few excel files, but I might build a SQL Database, because I need the hourly update (for 24 h a day). Do you think to build up a SQL database would be the easiest way to achieve the automatic updates?
Regards and thank you,
Lukas
lukas1,
"But if I get this right, in this case it is only possible to update through scheduled refresh (which is only possible 8 times a day)?"
In this case, when you change data in Excel source file, you are only able to set schedule refresh for your dataset to bring changes to Power BI Report. Unless you have Power BI premium license, you will be limited to refresh 8 times a day.
"Do you think to build up a SQL database would be the easiest way to achieve the automatic updates?"
Yes. you can use DirectQuery mode to connect to SQL database and achieve hourly refresh in Power BI Service.
Regards,
Lydia