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 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.
Hi All
i am happen to saw this post.
I like to know if I have all my CSV raw data at DropBox , And I need the PBI to perform a schedule refresh or reload during 3 Am. Can it be done ?Hope some one can share with me.
paul
Anonymous Not sure how getting/refreshing data from DropBox is at all related to the "Include in Report refresh" feature. For best response from the community, you may want to start a new thread, or even SEARCHING the forums for a similar topic. I fount several. Perhaps this thread will help:
https://community.powerbi.com/t5/Desktop/Data-source-hosted-on-Dropbox/m-p/48233#M19081
Best of luck.
I totally agree with you. I also tried my luck with support and had none...
Now I created a Idea for this topic. Hope I can get some Upvotes on it to get it going. -> https://ideas.powerbi.com/ideas/idea/?ideaid=44f7ca13-e8c9-eb11-ba5e-281878bdaa58
Anonymous
Thanks for confirming my understanding.
We ran into the same issue. The solution was to configure data sources on the gateway for sources that users imported once and that never change. Otherwise the gateway won't show up for the dataset because it is missing data sources. (They couldn't use "Enter data" because the amount of data was too big) That makes no sense, does it? Is there a was around this?
Can you elaborate on your technique stop refreshing what is essentially a 'static' table in a Power BI dataset, since there is no way with the Power BI Service to stop the service from refreshing specific tables?
We didn't change the default behaviour. It's more of a workaround. We simply load data from static sources that never change.
However, because it took us so long to provide the needed additional data sources via the gateway, our user took another approach: He loaded his static data in multiple "Enter Data" tables. He reported that you can paste up to 600 rows of data into the "Enter Data" experience so he split his data and union'd the tables again in query editor. Ugly, but it works for him.
Please help to upvote the idea to be able to change the default behaviour here!
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?
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.
