Forum Discussion
Encrypt and Decrypt in Power BI
Hi,
We have an encrypted column for staff no. in snowflake.I have to decrypt the same in power BI.
We already wrote a decrypt function (UDF) in snowflake.How can i call that decrypt UDF in power BI.
Regards,
Shivendra
1 Reply
Hi shivendraaa,
Currently, Power BI doesn't support connect to UDF of snowflake in Power BI directly. You can review the following links and check if it can be used as an workaround.
Custom SQL Now Supported in the Snowflake Connector for Power BI!
Extract Data from Snowflake using User Defined FunctionCurrently Snowflake connector doesn't support to bring User Defined Functions into Power BI. I found a similar idea about this requirement as below. You can vote it up.
Microsoft Idea - Power BI Support to call Snowflake Functions with Parameters that return Table
As User Defined Function is not supported, if your purpose is to filter data that will be imported into Power BI, you can use Power Query parameters as an alternative. In steps that filter rows with specific date columns, use date parameters to replace the fixed date values.
You can also create a custom function in Power Query. You can define query parameters for this custom function and let other users invoke this function to query data and generate a table result.
Using custom functions in Power Query - Power Query | Microsoft Docs
Power Query Custom Functions • My Online Training Hub
If the users are not report authors but report viewers, the Dynamic M query parameters in Power BI Desktop may be an option. It can let report viewers change parameter values at the report level. But this feature is only available for queries in DirectQuery mode and it has some limitations & considerations need to consider in advance.
Best Regards
