Power BI desktop allows you to refresh report page automatic & get latest data from database, currently it support only direct query mode. Also that is called APR(Automatic Page Refresh).
Requirement – Download & Install Power BI latest version from Microsoft official site.
https://powerbi.microsoft.com/en-us/downloads/
Limitation – It support only Direct query mode.
Let’s understand with an example-
Step-1: Load Data from SQL server to Power Bi Desktop using Direct Query mode.
Step-2: Page refresh option will be display under Format tab.
Step-3: Enable Page Refresh option then set time for page refresh.
Step-4: After set Page duration time, page will be automatically refreshed according to given time.
Watch Practical video:
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.