Need to select different tables based on month

[kgilmore33]

We have a SQL DB in Azure.  The application we use stores daily history records in tables organized by month.. so it creates a new table every month.  Fields are identical for each month, only the table name is different.

Is there a way to walk through the tables needed based upon a time slicer and grab the data from only the tables I need to use or even all the tables if needed?  

tables names (i.e):

sqlt_data_1_2019-01

sqlt_data_1_2019-02

sqlt_data_1_2019-03

sqlt_data_1_2019-04

etc..

[v-yulgu-msft · Accepted solution]

Hi @kgilmore33 ,

Slicer cannot filter the loaded datasets. If you want to load dataset dynamically based on selection, you could consider query parameters.

Best regards,

Yuliana Gu