Forum Discussion
Disabling "Include in report refresh" not working
Anonymous,
" These PBIX are published in the Cloud and are scheduled to refresh themselves overnight as well as during the day."
"Include in report refresh" option only works for Power BI Desktop, it doesn't impact the refresh process in Power BI Service.
In Power BI Desktop, when you disable "Include in report refresh" option, data will not update in report view of Power BI Desktop after you click "Refresh" button in Desktop.
Regards,
Lydia
Anonymous,
" These PBIX are published in the Cloud and are scheduled to refresh themselves overnight as well as during the day."
"Include in report refresh" option only works for Power BI Desktop, it doesn't impact the refresh process in Power BI Service.
In Power BI Desktop, when you disable "Include in report refresh" option, data will not update in report view of Power BI Desktop after you click "Refresh" button in Desktop.
Regards,
Lydia
Anonymous
I'm very confused with this.
So it means "Include in report refresh" option only affect PBI desktop, but when you refresh dataset in PBI service, the table still be refreshed, right?
Is that still correct now?
When I last tired it (see Post) it prevented the refesh also in the service. But it would still need access to the datasource.
So if you have a datasouce that's just accessbile for your PBI Desktop, the refresh would still fail. Since the check which tables to refesh was done only after the check if there is access to the source.
But I have not tried since then.Ya, but my purpose is to refresh table which is NOT Include in report refresh. Ofcourse, normally I don't want it to refresh (both clicking refresh dataset manually and schedule refresh), but sometimes there is an update, that I want to refresh that table in PBI service, so how to do that?
Anonymous If you have a dataset that is flagged as DO NOT INCLUDE IN REPORT REFRESH, I think the only way to refresh it is manually in Power BI Desktop. You must right-click on the table (in the Fields pane on the right) and select Refresh Data. Then you must re-deploy that refreshed model to the service. I don't think there is a way to manually refresh it from within Power BI Service.
Hint: This is a great way to refresh only ONE table at a time during development or testing, when you don't want to wait to refresh ALL of your datasets.
One other option is to take that dataset that you don't want to refresh and persist it as a DATAFLOW in the workspace. Dataflows can have their own Refresh schedule apart from other dataflows and models. In fact, the Dataflow need not have a Refresh schedule at all. This is a great work-around for data queries that don't change that often, like Zip Code lists, Employee lists, or Product lists.
Hope that helps
The "Include in report refresh" option affects both Power BI Desktop and the service equally. If unticked, the table will not be refreshed on either.
