Reply
Power BI Team
Posts: 21
Registered: ‎12-25-2016

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.

Frequent Visitor
Posts: 6
Registered: ‎12-13-2018

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

Occasional Visitor
Posts: 1
Registered: ‎11-27-2018

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
 
Frequent Visitor
Posts: 4
Registered: ‎12-20-2018

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.

Highlighted
New Member
Posts: 1
Registered: ‎12-26-2018

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

 

 

 

Frequent Visitor
Posts: 21
Registered: ‎04-12-2018

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

[ Edited ]

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. 

New Member
Posts: 1
Registered: ‎12-28-2018

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

Advisor
Posts: 17
Registered: ‎07-10-2015

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

[ Edited ]

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

Frequent Visitor
Posts: 5
Registered: ‎09-16-2018

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

[ Edited ]

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

Frequent Visitor
Posts: 5
Registered: ‎09-16-2018

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

[ Edited ]

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