Forum Discussion

Enigma's avatar
Enigma
Icon for Helper III rankHelper III
6 years ago

Redundant tables in model

Hi,    I have several tables in my report that are redundant once the data is transformed in Query Editor. And I am looking for ways to minmise the performance impact   Here's the situation: The...
Need Help
Enigma's avatar
Enigma
Icon for Helper III rankHelper III
6 years ago

Thanks mahoneypat 

 

I wasn't aware of the Enable Load option. There's also a 'Include in report refresh' toggle option.

I hope turning those off won't stop loading data in future iterations of data pull schedule. 

But thanks for suggesting.

I have a question - Does append queries happen after or before all applied steps are executed?

If it's after, then I can remove unwanted columns from each of the 10 tables and not just the 11th.

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Don't uncheck "Include in Report Refresh".  That is required for your next refresh.  Just uncheck Enable Load.

Regards,

Pat