Forum Discussion

VoltesDev's avatar
VoltesDev
Helper V
5 years ago

Get Data from Power BI Desktop using Azure Data Lake Gen2

Dear experts,   Is anybody can guide me how to use Data Lake Gen2 from Power BI Desktop ? On the URL, which part of the URL I should key in and how to bring all those files so that we can use it i...
Tutorial Requests
VoltesDev's avatar
VoltesDev
Helper V
5 years ago

Thanks amitchandak 

 

I found that also, but first of all, I want to connect it directly in Power BI Dekstop, so not from Power BI Services Data Flow.

The 2nd link is almost near, but it suggested me to click the binary, which is fine if we have only 1 TXT file, but I have more than 10, it is looks tedious since it is mean when click Binary at one line means it only imported 1 (table) only. Then I have to re-do to connect again and click Binary for the 2nd row which means 2nd table... and so on. Means 10 files, then 10 repeating actions.

The 3rd link is not suitable for me as it is to Combine all the files, which in my case, I need to have it separated as they were. Each files served it own purposes and have it own structure.

 

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    You can combine files with this button

     

     

    • VoltesDev's avatar
      VoltesDev
      Helper V
      5 years ago

      Thanks, but I don't want to Combine. 

      But I do want to import it one time only. So Get Data one time only to import all those  files and be a separate Tables each in Power BI Desktop,

       

      Thanks,