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: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

nikkiwaghani1
‎08-02-2022 10:00 AM

ADLS Gen2 and Azure Blobs SAS Key Connectivity

You can now connect to Azure Data Lake Storage Gen 2 or Azure Blob Storage using Share Access Signature (SAS) Keys! This option will replace the need to connect through the Web Connector, which can leave your SAS key exposed. This feature will come to PowerBI Desktop in August.

To connect to ADLS Gen2 or Azure Blobs using SAS Keys:

  1. Navigate to powerbi.com.
  2. In your workspace, create a new Dataflow or Dataset.
  3. On the “Choose data source” page, search for your data source (ie. “Azure Data Lake Storage Gen 2” or “Azure Blobs”) and select a source.

On_the_Choose_data_source_page_in_the_Power_BI_Online_service_search_for_and_selOn_the_Choose_data_source_page_in_the_Power_BI_Online_service_search_for_and_sel
Step 3) Search for and select your data source
  • In the Authentication kind drop down, select the Shared Access Signature (SAS) option. To retrieve your SAS token, go to portal.azure.com, navigate to your resource, and, under Security + networking, select shared access signature and scroll down to view the SAS token. Paste the value into the box and select next.
    Select_Shared_Access_Signature_SAS_from_the_Authentication_kind_drop_down_and_paSelect_Shared_Access_Signature_SAS_from_the_Authentication_kind_drop_down_and_pa
    Step 4) Select "Shared Access Signature (SAS)" from the Authentication kind drop down and paste the SAS token for the data source
  • Proceed with the rest of the data transformation as usual!
    • 0