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

I see Authorization errors on storage (the spikes you've shared before), since you confirmed that you've set up the storage according to documentation, I'll be reaching out to storage team to understand the issue.

lhanegraaf Frequent Visitor
Frequent Visitor

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

Hi all,

 

I experience the same issue as described by Steve, got this working until step 2, but then got the following error, when I pressed 'continue'.

 

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: f53bf51e-984e-4706-9667-49ab5ef8c6a5

Request ID: 12daf846-e59f-7254-a62a-3ee0bfa3e305

Correlation ID: 7bb1b282-ece4-856c-0c7e-8b8fdb9097f3

Time: Thu Dec 20 2018 14:26:34 GMT+0100 (West-Europa (standaardtijd))

Version: 13.0.7683.188

Cluster URI: https://wabi-west-europe-b-primary-redirect.analysis.windows.net

 

When I look at the 'request breakdown'-graph on the dashboard of my datalake, I don't see errors of 'ClientOtherError' at the time that I tried to connect to the lake via PowerBI. (as described by xuanalytics)

Power BI Team yehong
Power BI Team

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

Hi lhanegraaf,

Both you and Steve experience different issue from what xuanalytics experience.

Looking at your session traces you both fail to attach external storage since you miss Global Administrator role as required here: https://docs.microsoft.com/en-us/power-bi/service-dataflows-connect-azure-data-lake-storage-gen2.

Can you try again with a user that has Global Administrator role and update us?

lhanegraaf Frequent Visitor
Frequent Visitor

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

Hi Yehong,

 

Allright clear!

 

I managed to try it with Global Administrator rights (on the same account), but still have little success:

 

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: 2aa13457-2360-47d0-8bda-0ff8e6cb0428
Request ID: 74af588b-63d5-f31f-6874-42cf4fac39d9
Correlation ID: fb58b233-080f-9204-0875-2a61b82356ae
Time: Thu Dec 20 2018 15:29:33 GMT+0100 (West-Europa (standaardtijd))
Version: 13.0.7683.188
Cluster URI: https://wabi-west-europe-b-primary-redirect.analysis.windows.net

 

It shows me the 'almost done' message before displaying the error. (This wasn't the case before, but not sure whether that makes a difference?)

 

Thanks!

Power BI Team yehong
Power BI Team

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

General note -- we are working on improving the error handling in this scenario.

 

For your specific issue, it seems from traces that you didn't configure the filesystem correctly (didn't create 'powerbi' file system? didn't set correct permissions on root?) - filesystem setup starts here: https://docs.microsoft.com/en-us/power-bi/service-dataflows-connect-azure-data-lake-storage-gen2#cre...

 

Can you let us know this solved your issue?

b5lurker
Advisor

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

I was able to get my login setup with the Global Admin role and after I signed out of Power BI and signed back in with the credentials that have been attached to the Global Admin it sat on the Almost Done message for quite a bit longer then it has before, but still ended up with the "Something went wrong" message. Below are the error details:

 

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: a2de8002-2fa2-45f1-bc6f-50d8403a4b9d
Request ID: c895f191-8ad8-79a9-bc46-27e9c6495712
Correlation ID: 14645bcf-3862-8786-24de-b0d03a3f5946
Time: Thu Dec 20 2018 08:32:25 GMT-0700 (Mountain Standard Time)
Version: 13.0.7683.188
Cluster URI: https://wabi-west-us-redirect.analysis.windows.net

 

As far as I know I have the powerbi blob container and security all setup for the Power BI Service, Power BI Premium and Power Query Online application Object IDs, so not sure what else is missing to get this working. I have also setup the ADLSg2 resource in the West US region, so it is in the same region as our Power BI tenant now.

 

Thanks,

Steve

healthEteam Regular Visitor
Regular Visitor

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

Same here - updated the Azure Storage Explorer, was able to assign all accesses to the object ids as directed.

 

Still get this same message from Power Bi:

 

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 ID06c5229a-4491-4e95-af0c-2f467c35767f
Request ID07ed9dbc-a104-0953-e079-576d524036ff
Correlation ID5954e326-7c05-59e7-3bd7-6b9bc5eab410
TimeThu Dec 20 2018 09:33:21 GMT-0600 (Central Standard Time)
Version13.0.7683.188
 
Has anyone actually got this to work yet?
Power BI Team yehong
Power BI Team

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

Hi Steve, from looking at your traces it seems that you're hitting the same issue as lhanegraaf. We're waiting for response from Azure Storage team and will update you.

Power BI Team yehong
Power BI Team

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

Hi healthEteam,

 

From looking at your traces it seems that that storage account is not located at the same region of your tenant. From the setup manual, "The storage account must be created in the same region as your Power BI tenant. To determine where you Power BI tenant is located, see where is my Power BI tenant located."

Can you please tell if placing the storage in your tenant's storage solves the issue?

xuanalytics Frequent Visitor
Frequent Visitor

Re: Power BI Dataflow to Azure Data Lake Gen2 Setup

Both region are West US set since the beginning. Thanks.

 Storage location.PNGPBI location.PNG