Forum Discussion

NaukkaUKKO's avatar
NaukkaUKKO
Frequent Visitor
4 years ago
Solved

API request what needs HMAC SHA-256 encryption

Hello,   I need to request data from API to Power Query, but request payload needs SHA-256 encryption. Googling reveals years old posts where people state that its not possible to use this cryptogr...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi NaukkaUKKO ,

     

    There is no HASH encryption in Power Query. But, Power Query supports Python script. Then you can copy the code you provided in Power query.

    The type of python script result is json, you can use power query funtion Json.Document() to receive this result.

    Run Python Scripts in Power BI Desktop - Power BI | Microsoft Docs

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi NaukkaUKKO ,

 

There is no HASH encryption in Power Query. But, Power Query supports Python script. Then you can copy the code you provided in Power query.

The type of python script result is json, you can use power query funtion Json.Document() to receive this result.

Run Python Scripts in Power BI Desktop - Power BI | Microsoft Docs

 

Best Regards

Community Support Team _ chenwu zhu

 

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