Forum Discussion

Nandu2520's avatar
Nandu2520
Helper I
3 years ago

Get SAS token dynamically in Power BI

Hi,

 

I have azure blob storage with blob files. Blob storage is configured with private end point.

In Power BI when downloading the files I am using SAS token along with blob url. Currently I am hardcoding the SAS token value as parameter in Power BI.

 

What are the possible options to get the SAS token dynamically from Azure blob storage in Power BI.

Please suggest. Thanks

Need Help

3 Replies

  • NandanHegde's avatar
    NandanHegde
    Super User
    3 years ago

    Based on my understanding, it is not possible to get the SAS Tokens dynamically within PowerBI as PowerBI doesnt have support to key vault yet.

    You would have to wirte some custom logic via Python or Powershell to get the SAS Token at run time (you can leverage Power automate as well if need be)

    • Nandu2520's avatar
      Nandu2520
      Helper I
      3 years ago

      Can we invoke this Python/Power shell script directly from Power BI?

       

  • MSPBI_Starter's avatar
    MSPBI_Starter
    Frequent Visitor
    2 years ago

    Was anyone able to find out "how can one generate SAS token for Data Lake Gen 2 account on the fly" ?