I have a SQL Database in Azure and I connect Power BI reports with it. Now I want to refresh my Power BI dashboards automatically. I heard we can do it on Azure, but unable to find any documentation on it.
Have anyone done this before?
Please, share some documentation that I can use to do this!
First you need to make sure that the dataset in the report is updated. If you are using Direct Query, it will connect to your database directly and no refreshing is needed. However, if the data is imported, you need to schedule a refresh for this dataset. For Pro accounts, you can schedule up to 8 refreshes per 24 hours, or up to 48 for Premium.
Then when you pin tiles to a dash board, this dashboard will be updated automatically (refreshed every 15 minutes).
You can find more details in Data refresh in Power BI article.