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
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
Thank you ToddChitt
I consider this is a shortage of Power BI service. We obviously have demands to do so but PBI service just cannot serve that. The way I am doing now is refresh it manually in desktop version and re-deploy it as you said and it's not convenient. That's why I'm here to ask for another way.
For DATAFLOW way, I have try creating but it is apparently not an easy way.
So seemingly I have no choice sticking with re-deploy way and wait for next update of PBI service.
Hello Anonymous What did you mean by "For DATAFLOW way, I have try creating but it is apparently not an easy way."?
What is the data source type you are trying to make into a Dataflow? SQL? Excel? CSV? Something else? What have you tried and what are your pain points?
It's just complicated and I have read some articles in MS but still don't know how to use, what to do. I have REF (reference) table which is not usually refresh. I have done the report in the traditional way, import everything and create in desktop version and deploy to service.
Now I've done creating my REF in dataflow (import a table from xlsx file). Then I don't know how to use it, how to link it to my report.