Using dynamic M Query parameters of different pbix to another pbix

[ganotra_2730]

I have 2 pbix file report1.pbix where I am fetching data using direct query mode and in report2.pbix I am using the data in slicers from report1.pbix using power BI dataset and then using direct query mode  to fill data in table in report2.pbix based on filtering done in slicer I want to use dynamic M query parameter but the M query parameters that I have created and binded in report1.pbix are not visible in report2.pbix where I want to use them please provide the solution for this.

[rohit1991]

hi @ganotra_2730 ,

To use dynamic M Query parameters across two Power BI reports:

1. Enable DirectQuery for Datasets:

   • In Report2.pbix, enable DirectQuery for Power BI Datasets and AS under Options.

2. Replicate Parameters in Report2:

   • Recreate the same M Query parameters in Report2.pbix via Transform Data > Manage Parameters.

3. Bind Parameters in Report2:

   • Use these parameters in Power Query to filter data dynamically in Report2.

4. Share Parameter Values:

   • Use a shared source (e.g., SQL table, Excel, or SharePoint) to synchronize parameter values between reports.

5. Optional - Automate with REST API:

   • Use Power BI REST API to update parameters programmatically if required.

[Akash_Varuna]

Use the same dataset in report2 by connecting to the published Power BI dataset from report1.

M query parameters cannot be passed directly across different reports in Power BI Desktop.

Consider using slicers or filters in report2 to dynamically filter data based on the dataset.

Alternatively, replicate the parameter logic via DAX measures or Power BI Service parameters for dynamic filtering.