Encrypt and Decrypt in Power BI

[shivendraaa]

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

[v-yiruan-msft]

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 Function

Currently 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 ...

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 pa...

---

Best Regards