Include in Report Refresh Without Loading to Report

[Anonymous]

Hi, 

Is there any way to include a Query in the Report Refresh without loading the resulting dataset to the Report? At the moment when I go to the Properties of a Query it has the option to Load to Report without the Refresh but not the other way around. My thought here is that I want to have "Raw Data" tables which are updated when I click the Refresh button but I dont want them to appear in the Report Editor Fields pane, they should just exist as backend tables. They would have manipulated tables based on them which would be what I want to have exposed.

[MFelix · Accepted solution]

Hi @Anonymous ,

If you deselect the option Enable Load on the query editor the table will not be uploaded to the report however when you make the refresh the table will be refresh, if you have all the raw data being convert to other table then this is a good option for not showing unnecessary tables to your report.

If you need to have the RAW DATA tables to make DAX calculations or similar another option is on the report rigth click on the table you want and the Hide option this will take out the table from the visualization on the report but you can use it on measure and so on, they will be seen on the Data and Model view but greyd out.

Regards,

MFelix 

[Anonymous]

@MFelix 

I dont know about the first option, but right click to hide is just the ticket I was looking for. 

Thanks.