cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
krajani Member
Member

Disabling "Include in report refresh" not working

Hi everyone,

 

I have about 10-12 reports that load the same Calendar, a SSRS report, in their PBI reports. These PBIX are published in the Cloud and are scheduled to refresh themselves overnight as well as during the day. We have found from SSRS logs that the Calendar SSRS is being called a lot of times, which is unexpected as the Calendar query within PBIX has its “Include in report refresh” disabled. Is that not how it works, that is, disabling this option will stop PBI engine from going back to the data source, given there are no appends and merges within this query nor in other queries?

 

PBI -include-in-report-refresh-disabled.png

 

Thanks
kaz

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Disabling "Include in report refresh" not working

@krajani,

" 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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
12 REPLIES 12
Moderator v-yuezhe-msft
Moderator

Re: Disabling "Include in report refresh" not working

@krajani,

" 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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
krajani Member
Member

Re: Disabling "Include in report refresh" not working

@v-yuezhe-msft 

Thanks for confirming my understanding. 

Sokon Member
Member

Re: Disabling "Include in report refresh" not working

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?

 

SQLArchitect Frequent Visitor
Frequent Visitor

Re: Disabling "Include in report refresh" not working

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?

 

 

Sokon Member
Member

Re: Disabling "Include in report refresh" not working

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!

Highlighted
ToddChitt Member
Member

Re: Disabling "Include in report refresh" not working

@v-yuezhe-msft @krajani

 

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!

Sokon Member
Member

Re: Disabling "Include in report refresh" not working

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... 

ToddChitt Member
Member

Re: Disabling "Include in report refresh" not working

@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.

ToddChitt Member
Member

Re: Disabling "Include in report refresh" not working

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.