Forum Discussion
Automatic Refresh not displayed
Hi Dane
If you want to refresh in Service ,please refer to my reply above .
In Desktop , you can refresh in two place .
(1) Manual refresh in Desktop
(2) Place your mouse on the page, not on the visual, and then you can see the refresh setting in the Format settings. For specific operations, please refer to this link below .
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Dane
What I need to make sure is, do you mean refresh in Desktop or in Service ?
(1)In Desktop : Automatic page refresh in Power BI enables your active report page to query for new data, at a predefined cadence, for DirectQuery sources . For specific introduction and operation, please refer to the link below .
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh
(2)In Service : Scheduled refresh needs to install standard gateway and configure datasource gateway . The following links introduce how to install and configure the gateway, you can refer to the following .
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-manage
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-sql
After you complete the gateway installation and data source configuration , you need to configure scheduled refresh in Service , you can refer to the link below .
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your help. I need it to refresh in both desktop and service. In desktop I do not have the option for automatic refresh as shown in my screen shot below, this report uses SQL Server as its data source
I got into the same issue. However, mine was that I saw the "Page refresh" option under the Visualizations - Fomat Page (at the bottom) but I could not see it anymore when I installed and used the Power BI Desktop RS (report server Sept 2024 version). When I opened the same BI report on my old desktop version (Version: 2.119.986.0 64-bit (July, 2023)), it showed again.
Hope it help!
