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 Anonymous
Am I the only one reading this and thinking, "What the heck? That's POOR DESIGN by Microsoft!"
Disabling the "Include in Report Refresh" should mean just that, "don't try to refresh this data sourcr". It should NOT mean, "don't try to refresh this data source ONLY if you are using Power BI Desktop. But if you're using the Power BI Service, then try to refresh it!"
So the ONLY way to have a data source that does NOT get refreshed is to put it in a "Enter Data" table manually?!?
Sorry to say, but I'm VERY disappointed in MS for this design choice!
Not a very smart solution, I agree. But the most likely solution would be to provide a never changing datasource like an Excel and always load static data from there. You'd have to create an additional gateway data source though and might have a lot of unnessesary network traffic...
SokonSorry, but that's known as 'defect support system'
What happens if the location of that static data moves? You don't NEED to refresh it, but Power BI Service FORCES you to, and then FAILS because it's not there.
<rant>
This is a horrible design spec, where the desktop tool does something different than the service.
<\rant>
Sorry, but it's just my opinion.
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...
All:
Apparently, the July '20 Desktop update should fix this, but I think you need to open the model in that version (or later), save, then re-publish. FYI the July update is 'V3' and included the "enhanced metadata format" that is needed for this setting to be visible and usable by the service.