Query properties - disabling load to report while including in the dataset refresh

[Giorgiik_90]

Hello All,

I've encountered a problem in desktop app (Jun18 release): 

What I am trying to buildup is appending 10 individual queries together (10 excel files, regularly updated on the sharepoint) into 1 table, which is than going to  be loaded into the report. I do not need those 10 source files to be loaded as I will not buildup any visuals around those.

Therefore I thought unchecking "Enable load to report" field in the Query Properties and keeping the "Include in report refresh" checked would work. What I found out is that the second checkbox is always automatically unchecked when I try to disable the load to report option. This would basically mean that data won't refresh at all in my opinion, right?

...thought that the setup "disable load & enable refresh" was previously possible...

I welcome any help on this topic.

Thank you in advance,

Jiri

[v-chuncz-msft · Accepted solution]

@Giorgiik_90,

It affects only the current query.

[Giorgiik_90]

@v-chuncz-msft Thank you - actually your note helped as I forgot I need to do right click in the query pane, not the query properties :).