Forum Discussion

kgilmore33's avatar
kgilmore33
Regular Visitor
7 years ago
Solved

Need to select different tables based on month

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..

 

 

Need Help

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    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