Using Temp Tables and Dynamic Parameters

Hi,

I need to create a report where users can pick the start and end dates. I can do that using the parameters, passing the parameters into the query, and then using the slicers.

The challenging part is that there're temp tables in all queries. temp tables work in import mode only while the dynamic parameters require the direct query mode.

Is there a workaround to deal with this issue?

thanks,

Kamil