Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Paramterize Drill through

Hi All,

I have a summary report which has last 10 years of data with below fields:

Posting Date, Weekend Date, Month, Year,  Reason Code, Description, Adj Out $,Total Eaches Out

 

Here last 2 columns are measures rest all dimenssions. Now if user wanted to have drill through on Posting Date/ Reason Code from summary. Then the drill through should pass the patametres to the detail report and query should run only for those parametres on which the drill through is done.

 

Say user clicked on Posting Date 08/01/2018 and clicked on drill through and selected the Detail Report tab, then detail Report query should only run for 08/01/2018 and display data. 

 

The reason I need this functionality ,the summary going to have 10 years of data, for which I can not have detail query runing and stored data in PBIX, hence looking for an option of running the query dynamically on the base of drill trhough value.

 

Any suggestions please.

 

Thanks

 

Need Help

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

     

    Maybe you can try the preview feature desktop-composite-models. The drill through table will be in Direct query mode. Then you don't need to load all the data. But it will be slow if you have a large dataset.

     

     

    Best Regards,

    Dale