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

healthEteam's avatar
healthEteam
Resolver I
7 years ago

I was coming here to post about the exact same problem.

I cannot get past that step either.

 

It seems that those users (object ids?) seem to already need to be populated in the list because anything I put into the line as far as new user and hit "Add", it fails to find.

 

Hopefully someone has gotten past this and can provide some insight.

Seems like just a step missing in the documentation.

 

I see MatthewRoche is providing feedback on some of the datflows posts.  Maybe he can help us.

MatthewRoche's avatar
MatthewRoche
Microsoft Employee
7 years ago

Hi healthEteam - Unfortunately I'm still working throigh the same process. I'll help when I'm able, but it will likely be a day or three...

  • healthEteam's avatar
    healthEteam
    Resolver I
    7 years ago
    Great - thanks for responding.
    Everything I know about dataflows thus far have been from your presentations.
    So figured if anyone would know it would likely be you.
    Glad to know you are still working through it as well.
    • MatthewRoche's avatar
      MatthewRoche
      Microsoft Employee
      7 years ago

      Thank you!

       

      (Blushing furiously)

       

      One of the benefits of working at Microsoft means that I get to play with all the cool toys...


      ...but to test this feature end to end I need to set up my own Power BI tenant, and that isn't fitting into my week so far.  :-(