cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Power BI Team yehong
Power BI Team

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

xuanalytics, please note that my comment about incorrect region was directed to healthEteam.

 

We're still waiting for a response from Azure Storage team for your issue (you managed to attached storage but fail to create dataflows on top of it). Will update you once we reiceve their response.

joshbrownwsna Frequent Visitor
Frequent Visitor

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

Hi Eveyone,

 

I tried again this morning just to make sure I am still getting the same error. I am and am in the same boat as xuanaltyics.  Pasting it below incase its helpful for the storage team.  Any help figuring this out is greatly appreciated! Thank you everyone for your time!

 

Something went wrong
Unable to save the dataflow.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: f617af12-4384-4fb6-a8e8-0a84bdfe0977
Request ID: 74bb234b-89de-4bf3-0fe9-2d062ed3d3e0
Correlation ID: 1b76189c-c3ae-ffd6-0ab6-1b5f7ad05176
Status code: 500
Time: Thu Dec 20 2018 09:23:56 GMT-0800 (Pacific Standard Time)
Version: 13.0.7683.188
Cluster URI: https://wabi-west-us-redirect.analysis.windows.net

 

Josh

markusth Frequent Visitor
Frequent Visitor

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

I surely checked several times that I followed all steps to connect my ADLS gen 2 to Power BI, but I still get no success. 
  1. I made sure the ADLS is in the same location then my PBI tenant (in my case North Europe)
  2. I give the PBI Service access with the reader role
  3. I give PBI Svc and Power Query full access to the container folder "powerbi"
  4. I even tried full access to all 

any suggestion why I still get no success?

 

Aktivitäts-ID14edddab-cb86-48c7-9ce4-6ffc3e48c1ac
Anforderungs-ID7eb3a30d-892c-c8fc-a5ba-018643494695
Korrelations-IDac823118-22e0-3bc8-a0fb-60d41fde1b62
ZeitFri Dec 21 2018 12:54:24 GMT+0100 (Mitteleuropäische Normalzeit)
Version13.0.7683.188
 
lhanegraaf Frequent Visitor
Frequent Visitor

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

Hi Yehong,

 

Thanks for your help, but it didn't succeed unfortunately.

I already set it up the way that is described in the article you linked. However I tried setting it up once again, but without success.

julioleite Frequent Visitor
Frequent Visitor

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

I am with the same issue. Checked the points several times and got the error.

Screen Shot 2018-12-26 at 23.35.50.png

 

 

 

sagivh Frequent Visitor
Frequent Visitor

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

Hi everyone, we acknowledge the reported setup issues. we have found a potential issue in Azure Storage Explorer and are working on a mitigation. 

We will update this post when we have more information and ETA. 

 

Thank you. 

RyanTheDataBus New Member
New Member

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

Hi,

 

I'm having the same issue.  Looking forward to any help you can provide.

 

Cheers,

Ryan

 

Something went wrong
Error while connecting your Data Lake Storage account
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 20b9daf2-da0e-4dc0-a266-b8aecd433a94
Request ID: c86756c0-210b-13ec-23a6-a1ea7d6de12e
Correlation ID: afa24dbe-d215-d05f-12e4-ae9ae7fa3c46
Time: Fri Dec 28 2018 13:27:05 GMT-0800 (Pacific Standard Time)
Version: 13.0.7683.188
Cluster URI: https://wabi-us-north-central-b-redirect.analysis.windows.net

ruiromano
Advisor

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

Hi,

 

Same issue here Smiley Sad

 

Error:

 

Activity ID7ae90109-cd7f-4caf-a342-0a0c1700a3b3
Request ID9385312a-6d0c-133b-4530-72f88ad0bbbb
Correlation IDd36f7917-72d5-f8dc-5567-7a220a6c640f
TimeSat Dec 29 2018 17:21:23 GMT+0000 (Western European Standard Time)
Version13.0.7683.237
Cluster URIhttps://wabi-west-europe-redirect.analysis.windows.net

Highlighted
Michael7 Frequent Visitor
Frequent Visitor

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

Hi,

 

There is a temporary issue with settings ACLs through Microsoft Azure Storage Explorer, until this is resolved, as a temporary mitigation you can try using this powershel script: https://setacls.blob.core.windows.net/scriptfolder/setacls.ps1

 

In order to run the script, your global tenant admin needs to have "Storage Blob Data Contributor (Preview)" role on your storage account.

 

Instructions on how to run this script:

     

  1. Login as global tenant administrator into Azure portal and open PowerShell (Cloud Shell) in your browser
  2. Choose Azure CLI 2.0 (type ‘az’)
  3. Upload the script (there is a button for it)
  4. Run the script. For example:  /home/admin/setacls -storageaccountname your_alds_gen2_storage_account_name
    The script will ask you to sign in, please follow the instructions.

 

Thanks,

Michael

 

Hi,

 

There is no more need in this workaround, please use ASE 1.6.2 which is availably for update and download.

 

In order to update:

ase.png

 

For download: https://go.microsoft.com/fwlink/?LinkId=708343

 

Thanks,

Michael

Michael7 Frequent Visitor
Frequent Visitor

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

Hi,
 
There is a temporary issue with settings ACLs through Microsoft Azure Storage Explorer, until this is resolved, as a temporary mitigation you can try using this powershel script:https://setacls.blob.core.windows.net/scriptfolder/setacls.ps1
 
In order to run the script, your global tenant admin needs to have "Storage Blob Data Contributor (Preview)" role on your storage account.
 
Instructions on how to run this script:
    
1. Login as global tenant administrator into Azure portal and open PowerShell (Cloud Shell) in your browser
2. Choose Azure CLI 2.0 (type ‘az’)
3. Upload the script (there is a button for it)
4. Run the script. For example:  /home/admin/setacls -storageaccountname your_alds_gen2_storage_account_name

 

The script will ask you to sign in, please follow the instructions.
 
Thanks,
Michael

 

 

Hi,

 

There is no more need in this workaround, please use ASE 1.6.2 which is availably for update and download.

 

Thanks,

Michael

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 290 members 2,874 guests
Please welcome our newest community members: