Power BI access to one Storage inside a vnet using Gateway

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. :)