Encrypt and Decrypt in Power BI

shivendraaa — Wed, 15 Jun 2022 06:35:06 GMT

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

Re: Encrypt and Decrypt in Power BI

Anonymous — Mon, 20 Jun 2022 07:09:26 GMT

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

topic Encrypt and Decrypt in Power BI in Developer

Encrypt and Decrypt in Power BI

Re: Encrypt and Decrypt in Power BI