Unable to filter data via parameter using PowerQuery(Snowflake as data source) in PBI Report Builder

Sonali_Sahu — Thu, 25 Jul 2024 08:52:12 GMT

Hi,

We are using Power BI Report builder for developing the Paginated report and have connected Snowflake as data source 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 bind them. While viewing the report, data is not getting filtered as per the parameters value selected. Attaching the screenshots for the reference. In the below screens, you can see that the filter is not working as expected.

Please suggest what could be the next steps or some workaround for the same.

@PowerBIReportBuilder

Snowflake

@PowerQuery

@Paramaters

Thanks,

Sonali Sahu.

Re: Unable to filter data via parameter using PowerQuery(Snowflake as data source) in PBI Report Builder

Anonymous — Fri, 26 Jul 2024 09:12:38 GMT

Hi, Sonali_Sahu

After changing the parameters, you may have overlooked the need to click "View Report" in the upper right corner

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Unable to filter data via parameter using PowerQuery(Snowflake as data source) in PBI Report Builder in Report Server

Unable to filter data via parameter using PowerQuery(Snowflake as data source) in PBI Report Builder

Re: Unable to filter data via parameter using PowerQuery(Snowflake as data source) in PBI Report Builder