Forum Discussion
Solved
power bi service(free) sql server data refresh
Hi All, I have developed reports on Power BI desktop and published them to Power BI service. I have used SQL server data source. I have simply integrated those reports in a custom web app using P...
- Hi there
Currently the Publish to Web feature will only update the cache once every hour.
Also with Power BI Pro or Power BI free you can only update the dataset 8 times a day.
If you had to delete and re-upload the PBIX you would then have to re-create the Publish to Web link as far as I know
If you are looking for something more real-time you could look into DirectQuery, this might work with Publish to Web, but best solution is to use a Power BI Pro license with DirectQuery which will work.
Hi there
1. Yes unless you configure the scheduled refresh, it will NOT auto refresh.
2. Currently unless you have got Power BI Premium you can only refresh 8 times a day.
Thank you so much for clarifying my doubts