Passing parameter from Power BI to a materialised view in snowflake

[Anonymous]

We have some requirements to pass parameter in run time from Power BI report to backend view which can accept parameter to show the result !!! Back end db is snow flake and if custom SQL is allowed in Power BI now to snowflake db.

Thanks.

Sandeep

[Icey]

Hi @Anonymous ,

I am sorry that I do not have similar experience. 

However, to my knowledge, Snowflake and SQL Server are all based on SQL engine. So, how about referring to the below posts to write back?

Write Back to SQL Database from Power BI;

Using Power Apps in Power BI reports: Enabling writeback.

Best Regards,

Icey

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

[amitchandak]

@Anonymous , refer id these can help

https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/