Power BI Dataflow to Azure Data Lake Gen2 Setup

(removed post duplicated of https://community.powerbi.com/t5/Service/Power-BI-Dataflow-to-Azure-Data-Lake-Gen2-Setup/m-p/595687/highlight/true#M59908)

yehong updating ASE to 1.6.2 I was able to connect Power BI Service to my ADL Store!!!! Too happy for that!

Thank you and sagivh so much!

My issue solved! Thank you yehong!

Hi all,

The problem is resolved after updating the azure storage explorer and adding Power BI service as a reader role on the data lake storage account.

Thank you all for the wonderful support,

Thanks

Bhavesh

Hi all,

Thanks! I can also confirm that this works for me! Great work!

Hi Anonymous,

Can you please briefly explain what are the series of steps performed to make this work successfully.

It would be really appreciated! I am trying all the recommended steps as explained by Michael7 but have no success.

This would really assist me in debugging the process.

Thanks,

Hi All,

Azure Storage Explorer version 1.6.2 is now available as an insider build, and I can confirm it has fixed the issue of setting ACLs as confirmed in its release notes: "In 1.6.1, entities added to ADLS Gen2 ACLs by ObjectId which were not users were always added as groups. Now, only groups are added as groups, and entities such as Enterprise Applications and Service Principals are added as users."

Here is what you can do to obtain it:

1. In Azure Storage Explorer, click on the Help menu, then Opt in to insider builds.

2. In Azure Storage Explorer, click on the Help menu, then Check for updates.

After a few moments, a notification bar will appear notifying you a new version is available with an option to install it. Once installation is complete, you can follow the instructions in Power BI documentation to complete the setup: https://docs.microsoft.com/en-us/power-bi/service-dataflows-connect-azure-data-lake-storage-gen2

Please let us know if you encounter any issues with setting up storage using Azure Storage Explorer 1.6.2.

(removed post duplicated of https://community.powerbi.com/t5/Service/Power-BI-Dataflow-to-Azure-Data-Lake-Gen2-Setup/m-p/595687/highlight/true#M59908)

Hi

You're right. After many tests I created new storage account and i miss this step.

But even after adding Reader role to it the integration still doesn't work.

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: 8c6c3ac3-ac67-4c4f-9433-0cf9ed8238c1
Request ID: b0ead637-031a-07ee-cb79-88ab611e177b
Correlation ID: b168ddcd-3e75-1a5e-8fd1-0fdb13396aa0
Time: Mon Jan 07 2019 10:05:00 GMT+0100 (Środkowoeuropejski czas stand.)
Version: 13.0.7840.225
Cluster URI: https://wabi-europe-north-b-redirect.analysis.windows.net

Regards

Maciek

So, now it's working.

Thanks for your help.

Regards

Maciek

I'm happy to hear that.

If you can tell, can you please share which of the methods you've tried? Did you get it after waiting some time? Or was it after the removal/add things started to work?

This can help other forum readers, in addition, we would like to communicate this back to storage team as part of our efforts to improve the experience.

First, I set access to powerbi folder on ADLS2 storage account using Storage explorer (1.6.1) and then i tried to enable connection PowerBI with ADLS2 without success.

Next i run script from Michael7 on the same storage account but nothing changed.

So I decided today to create new storage account and executing on them script from Michael7, then after correcting my mistake with missing  Read role (for PowerBI service) and waiting some time (around 30 minutes), connection from ADLS2 to PowerBI was created with success.

Regards

Maciek

Hi,

I've opted in for Insider Builds in ASE 1.6.1, set up Manage Access as required from the tutorial and assigned Power BI Service a Reader role for the storage account, but I still receive the following error when trying to connect the ADLS Storage from Power BI Service

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: 0d0cb805-f647-4f2c-b60b-fcbba8ce312e
Request ID: 6cc12836-acaa-33cc-d0da-efc259f45004
Correlation ID: da689ea8-6789-520a-078b-f62f4827f184
Time: Tue Jan 08 2019 13:46:21 GMT+0100 (Central European Standard Time)
Version: 13.0.7840.225
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net

Both my storage account and Power BI tenant are in region North Europe.

Can you please help me?

Hi Picci, can you please try again with 1.6.2 insider build? that is the build that includes the needed fix.

Thanks. 

Hi sagivh, thanks for your support!

Can you please send me the downloand link? Check for Updates has no effect currently in my desktop application for ASE.

Thanks,

Elisa