Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Nandu2520
Helper I
Helper I

Get SAS token dynamically in Power BI

‎01-23-2023 02:14 PM

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

Labels:
Message 1 of 4
880 Views
0
3 REPLIES 3
MSPBI_Starter
Frequent Visitor

‎01-02-2024 08:51 AM

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

Message 4 of 4
516 Views
0
NandanHegde
Super User
Super User

‎01-23-2023 07:38 PM

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)




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com
Message 2 of 4
825 Views
0
Nandu2520
Helper I
Helper I
In response to NandanHegde

‎01-27-2023 08:15 PM

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

 

Message 3 of 4
786 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

View All