Forum Discussion

Gopal_PV's avatar
Gopal_PV
Helper III
3 years ago

How to pass 2 parameters values to single procedure using m Language

Hi Folks,

 

Thank you in advance.

Tips and Tricks

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    Hi Gopal_PV 

     

    I think this is not possible currently. The closest feature is Dynamic M query parameters in Power BI Desktop. However this feature requires that you must have a valid M query that uses one or more DirectQuery tables. And a dynamic M query parameter is binded to a column field in one DirectQuery table. The dynamic part you want to change is the data source folder path while the dynamic M query parameter does not support to change the data source of a table. 

     

    Currently it is not supported to change the data source dynamically according to report users' interaction with a slicer or filter in the report. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.