Forum Discussion
Unable to filter data through parameters when creating the report using Power Query (data sources)
Hi,
We have connected Snowflake datasource by PowerQuery and mapped required parameters to the report query that were created under the report parameter section. In Report query, we have created parameters and have binded them. While viewing the report, data is not getting filtered as per the parameters value selected.
Please suggest what could be the next steps to follow.
@Parameters @PowerQuery Snowflake
Thanks,
Sonali Sahu.
2 Replies
There could be many different reasons for this not working. Since we don't see your scripts and configurations, it would be best for you to compare the step-by-step tutorial with your solution to identify differences. If you post your scripts and screenshots showing all of the configurations then we will be able to help more on this.
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
We are using Power BI Report builder for developing the Paginated report. Hence, we have created the parameters in Report query and Parameters section. Attaching the screenshots for the reference. In the below screens, You can see that the filter is not working as expected.
Please have a look and suggest some workaround if any.
Thanks,
Sonali Sahu.
