Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
darwindat
Helper I
Helper I

Connect PBI dataflow to ADLS Gen 2 located different regions

Hi,

I am trying to create a PBI dataflow connecting to an ADLS Gen2 account. This ADLS Gen2 is not the dataflow storage, it's just a storage that I want to connect to.

As a test, I connect from PBI dataflow to an ADLS Gen2 (located in the same region with my PBI Service, e.g. North Europe), it works. However, when I try to connect to the one located in a different region (West Europe), it fails (as seen in the screenshot below).

darwindat_0-1647501376591.png

Do you guys know how to fix it? Thanks in advance!
@v-easonf-msft I see that you answered the question in this post Dataflows Storage can't connect to ADLS Gen2 . Although it's not about the dataflow storage, but maybe you can give me an advice? Thanks!

 
5 REPLIES 5
darwindat
Helper I
Helper I

Hi @v-chenwuz-msft due to security reasons, it's not allowed to use the "Account key" authentication method, and I don't have the permission to change that ADLS Gen2 account to that "Account key" method as well.

Is there a solution for "Organization account" method to fix that issue? Thanks!

 
 
 
v-chenwuz-msft
Community Support
Community Support

Hi @darwindat ,

 

The Power BI workspace tenant region should be the same as the storage account region. (please refer this official article. Configuring dataflow storage to use Azure Data Lake Gen 2 - Power BI | Microsoft Docs)

You can move the workpace if you have Premium capacity.

Multi-Geo support for Power BI Premium - Power BI | Microsoft Docs

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-chenwuz-msft, thanks for the reply.
My question was about a normal ADLS Gen2 storage account, not the storage account that stores data created by the Dataflow. Basically, we have procedures to copy data from SQL server to that ADLS Gen2. Now I create a PBI dataflow and I want to ingest data from that ADLS Gen2 account. But if the PBI dataflow's location (same as PBI Service) is not the same as the one of ADLS Gen2, I fail to connect (as seen in the screenshot above).
Do you have any tips for that? Thanks!

 
 
 

Hi @darwindat ,

 

Can you try some other authentication methods, such as key authentication?

Maybe this helps and you can refer to it.

Analyze data in Azure Data Lake Storage Gen2 by using Power BI - Power Query | Microsoft Docs

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

darwindat
Helper I
Helper I

Just an addition. I got the same issue if I connect from PBI Service to ADLS Gen2.

darwindat_0-1647529170018.png

To be precise, I got no issue connecting and refreshing the data in ADLS Gen2 using PBI Desktop. But when I published it to PBI Service, try to change the credential to set up the refresh, it says the credential is invalid. 
I bet it's caused by the same reason.
I look forward to any advice from you guys! Thanks!

 
 
 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors