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
Actually, there is a better work-around now that DataFlows are up in GA:
Configure each Source in a DataFlow, and each DataFlow can have its own refresh schedule. So DataFlow1 can be static data. Refresh it once and never again. DataFlow can be the transactional data that gets refreshed regularly.
Then create a Power BI model that uses BOTH DataFlows.
ToddChitt: When the data really IS static, I don't care if the source moves, do I?
However, you are absolutely right with dataflows: I can put my data there once an load it in all my datasets without the need to setup and maintain an extra gateway data source for it. That makes things a lot easier!
I'd say it solves the problem, even when it hurts me to think about that data nevertheless being loaded into the datasets without need during every refresh...
SokonYes, I think you DO care as Power BI Service WILL try to refresh that data even if you don't need it to. So it always needs to be where the service can find it.
That's the beauty of Data Flows. You can refresh them once, and NEVER set up a Refresh Schedule, yet you can still reference them (and the cached data) in Power BI Desktop designer.
If you have read this far in the thread, and you are as frustrated at Microsoft for ignoring this issue, PLEASE go to User Voice at the below link and vote on the item. More votes means a better chance that Microsoft will sit up and take notice.
Thanks
So I have been monitoring the link above regarding the User Voice item, and also hounding Microsoft to A) acknowledge there is an issue and B) do something about it.
Last Week I did a quick test and discovered that it may have been fixed. I'm curious to know if ohter people are seeing the same (new and expected/corrected) behavior on the service regarding "Include in Report Refresh"
Nice it it has probably been fixed, but the User Voice item is still listed as "Needs Votes", and I have not seen any mention of it in Blogs, releases, or other official communication from Microsoft. Like they fixed it on the sly but are unwilling to admit that it was an issue to begin with.