Get SAS token dynamically in Power BI

[Nandu2520]

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

[MSPBI_Starter]

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

[NandanHegde]

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]

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