Forum Discussion
Using dynamic M Query parameters of different pbix to another pbix
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 quer...
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.