Forum Discussion

b5lurker's avatar
b5lurker
Advocate II
7 years ago
Solved

Power BI Dataflow to Azure Data Lake Gen2 Setup

Excited to see all of the new Power BI Dataflow capabilities especially with using Azure Data Lake Gen2 as the storage location for those Dataflows.   But, I have been trying to get it setup using ...
Need Help
  • Michael7's avatar
    Michael7
    7 years ago

    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

b5lurker's avatar
b5lurker
Advocate II
7 years ago

Some progress today!

 

I was able to get the 1.6.1 release of ASE installed today by Opting In on Insider Builds and checking for updates. Once that was setup I was able to complete the ACL changes for the Power BI Service and Power Query Online applications!

 

Now I'm stuck on the connection in the Power BI Admin panel where I have correctly filled in my Subscription ID, Resource Group Name and Data Lake Storage Account and it just shows a "Something went wrong" error:

 

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: 3dfbcee0-9cdd-4137-b626-31d40d8aa15a
Request ID: 4f8a2a8e-a28d-ee1d-39b2-f81c9e5048e0
Correlation ID: d56c5d02-bd2a-1afd-4dc9-29f46a15d640
Time: Fri Dec 14 2018 14:02:35 GMT-0700 (Mountain Standard Time)
Version: 13.0.7683.181
Cluster URI: https://wabi-west-us-redirect.analysis.windows.net

 

Not sure what is causing this error as there no other details provided. I do know that there is some text in the documentation about having your ADLSg2 setup in the same region as your Power BI tenant. Our Power BI tenant is in West US as you can see from the link shown in the error above. I was unable to setup an ADLSg2 storage account in West US, so the one that I'm trying to point to is in West US 2. Not sure if that is part of the problem or not, but it is the only thing that stands out for our setup.

 

At least we are a few steps closer now. :)

 

Happy Friday!

Steve

 

 

  • joshbrownwsna's avatar
    joshbrownwsna
    Frequent Visitor
    7 years ago

    Hi Everyone,

     

    I was also able to add the ACLs using the internal build. In addition, since my account was already connected, I was able to work through all the steps in the configuration document. 

     

    I also created a new workspace and was able to configure the workspace to use data lake storage. 

     

    Please note, this option is only available in workspaces created to view the new experience.  If your workspace has been created via an O365 group, you will not be able to configure it to use data lake storage.

     

    Unfortunately, when I try to save a workflow I get the following error:

     

    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: 6cf62757-8eed-4c8f-b89a-19e737873a62
    Request ID: 4ebf59ad-5980-ed22-5432-3f2915ef5446
    Correlation ID: 1f1bbc99-c76b-8c1b-54af-aaa270b10656
    Status code: 500
    Time: Fri Dec 14 2018 22:07:33 GMT-0800 (Pacific Standard Time)
    Version: 13.0.7683.181
    Cluster URI: https://wabi-west-us-redirect.analysis.windows.net

     

    So, unfortunately, no dice ... yet. But progress!

     

    Thanks to everyone for the help.  This has been a great thread!

     

    *** Update 12/16/18 ***

     

    Hi Everyone,

     

    Double checked my config tonight against the instructions laid out in https://docs.microsoft.com/en-us/power-bi/service-dataflows-connect-azure-data-lake-storage-gen2.  Noted my config appears correct, but still getting the 500 error.  Any help in review would be appreciated!

     

    Josh

    • xuanalytics's avatar
      xuanalytics
      Frequent Visitor
      7 years ago

      Hi Josh,

       

      I am getting the exact same error as you got. I configured everything according to the Microsoft document. But I am not able to save any data flow in the new app workspace which Data Lake Storage enabled. I have then checked teh activity log of the storage account and I found everytime I am trying to save it 

       

      • yehong's avatar
        yehong
        Power BI Team
        7 years ago

        Hi xuanalytics - are you seeing the failures in PowerBI portal? can you please share the "Something went wrong" message contents?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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)

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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!