Forum Discussion
question about refresh settings
Hello,
My report is based on API calls and a connection to Active Directory.
I want for some reports to allow the user to refresh them himself, and for other I would like to put in place an automatic refresh (daily let's say).
I saw 2 things about the refresh :
- need to go through a gateway
- and/or setting the following parameter :
The problem is that I don't see this "Page Refresh" panel when I build my report.
I have tried in parallel to install the gateway but I am not authorized yet to do so by my company's policy.
So can you enlight me about the difference between this "Page Refresh" panel and the need of a gateway ?
How can I make this "Page Refresh" panel appear in Power BI ?
Thank you,
Hi Anonymous ,
Date fresh :
import: Power BI imports the data from the original data sources into the dataset. Power BI report and dashboard queries submitted to the dataset return results from the imported tables and columns. You might consider such a dataset a point-in-time copy. Because Power BI copies the data, you must refresh the dataset to fetch changes from the underlying data sources.
Direct query:Power BI doesn't import data over connections that operate in DirectQuery mode. Instead, the dataset returns results from the underlying data source whenever a report or dashboard queries the dataset. Power BI transforms and forwards the queries to the data source.Because Power BI doesn't import the data, you don't need to run a data refresh. However, Power BI still performs tile refreshes and possibly report refreshes, A tile is a report visual pinned to a dashboard, and dashboard tile refreshes happen about every hour so that the tiles show recent results. You can change the schedule in the dataset settings, or force a dashboard update manually by using the Refresh now option.
automatic page refresh:
only available for direct query data sources. All it does is emulate user activity.
When automatic page refresh is enabled, Power BI Desktop is constantly sending queries to your DirectQuery source. After the query is sent, there's a delay before data is returned. So, for short refresh intervals, you should confirm that queries are successfully returning the queried data within the configured interval. If data isn't returned within the interval, visuals will update less frequently than configured.
To learn more details ,refer:
https://community.powerbi.com/t5/Desktop/Automatic-page-refresh-in-Power-BI/td-p/1439148
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Lucien
2 Replies
Anonymous going thru gateway and page refresh are two different things.
Schedule on Power BI dataset will use Gateway to refresh the data and the page refresh will refresh the visuals on the page using the current dataset.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Hi Anonymous ,
Date fresh :
import: Power BI imports the data from the original data sources into the dataset. Power BI report and dashboard queries submitted to the dataset return results from the imported tables and columns. You might consider such a dataset a point-in-time copy. Because Power BI copies the data, you must refresh the dataset to fetch changes from the underlying data sources.
Direct query:Power BI doesn't import data over connections that operate in DirectQuery mode. Instead, the dataset returns results from the underlying data source whenever a report or dashboard queries the dataset. Power BI transforms and forwards the queries to the data source.Because Power BI doesn't import the data, you don't need to run a data refresh. However, Power BI still performs tile refreshes and possibly report refreshes, A tile is a report visual pinned to a dashboard, and dashboard tile refreshes happen about every hour so that the tiles show recent results. You can change the schedule in the dataset settings, or force a dashboard update manually by using the Refresh now option.
automatic page refresh:
only available for direct query data sources. All it does is emulate user activity.
When automatic page refresh is enabled, Power BI Desktop is constantly sending queries to your DirectQuery source. After the query is sent, there's a delay before data is returned. So, for short refresh intervals, you should confirm that queries are successfully returning the queried data within the configured interval. If data isn't returned within the interval, visuals will update less frequently than configured.
To learn more details ,refer:
https://community.powerbi.com/t5/Desktop/Automatic-page-refresh-in-Power-BI/td-p/1439148
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Lucien
