This guide overview has the objective of explaining a solution for connecting Azure Storage with Power BI tools using a gateway to connect the Storage inside the private endpoint, resolving the follow issues:

1. Power BI Desktop — ADLS direct connection

Provide a solution to Power BI Desktop access an Azure Storage account behind a private endpoint.

2. Power BI Desktop — Publish report

3. Power BI Service — ADLS gateway connection

Provide a solution to Power BI portal refresh a Dataset that connect to one Azure Storage account behind a private endpoint.

Requirements

Allow the Storage <storage account_name> in the private endpoint access.

Allow the <user> access the <storage account_name> as “Storage Blob Data Reader” and “Reader”.

Install an Azure Gateway to the VM with ADLS access. Configure the Gateway and Datasource and Allow <user> to access to the Gateway and Datasource in the PowerBI Services (Portal).

Power BI Desktop

To allow the Power BI Desktop to access directly to the Azure Storage account, follow these steps:

  1. In PowerBI desktop go to “Get data” and “More”.
  2. Select “Azure” and “ADLS Gen2”:
  3. Fulfill the URL field with the <container_access_url> and then click “OK”.
  4. Click in “Sign in”
  5. Add your corporate user/pass and then click “Connect”.
  6. Then click the action that you wanna do.

Power BI Services

To allow the Power BI Services to refresh the Dataset with data from Azure Storage account, follow these steps:

  1. Save and Publish the report created in the step above.
  2. Select the workspace that you want to save.
  3. Go to https://app.powerbi.com/ and sign in with you corporate user/pass.
  4. Go to the Dataset that you just created and select “Settings”.

5. Add the gateway to the Dataset:

(2) Select “on” in the option “Use a data gateway or VNET”.

(3) Select the <gateway_name>

(4) Select the <datasource_name>

(5) Click “Apply”

6. Go to the Workplace, select the dataset and click in “Refresh”

Did you find this article relevant? Do you want to know more about ? Do you or your company have a similar problem? Please contact me and I will not hesitate to charge you to resolve. I’m kidding. :)

Expert in software development and data manipulation.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Embedded System Project #2 : Digital Input & Output

How to learn Magento development

TryHackMe Boiler CTF

Menu Driven Program

Try to Explain Quantum Computing and Q# to Non-Physicists 1: What is Quantum Computing, Q# and…

Integrated Solutions — 6 Valuable Reasons To Use iPaaS

How To Hunt on Sysmon Data

Trust Wallet Logo Confirmation!

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Samuel JB

Samuel JB

Expert in software development and data manipulation.

More from Medium

Mapping and Creating Mappers; Key Ingredients for Defining Our World

Advent of Cyber 3 Day 11 — Where Are The Reindeers? Walkthrough

Top 5 Embedded Analytics Tools for Azure SQL Database (Plus 1 Bonus Option)

Yurbi - Embedded Analytics BI Software

Getting Started with Talend Open Studio | Reading CSV File Using Talend Components