Forum Discussion

Sonali_Sahu's avatar
Sonali_Sahu
Frequent Visitor
2 years ago

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

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.

Get help from Power BI community
tips & tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.