Get Data from Power BI Desktop using Azure Data Lake Gen2

[VoltesDev]

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 inside Power BI Desktop ? and threat  those files as tables so we can create Data Model after it.

Sorry for this many question for start.

Thanks in advance.

[v-shex-msft]

Hi @VoltesDev,

>>I want to connect it directly in Power BI Dekstop, so not from Power BI Services Data Flow.

AFAIK, power bi desktop already supports the azure data lake gen2 connector, you can use this to directly get data from your data sources.

>>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,

In fact, your scenario not able to directly get data and split them to subquery form on data source. Power bi gets data step will auto-create multiple query tables if you choose multiple target tables.(duplicate connector data step and navigation to specific target data tables)

Your scenario needs to further analyse and recognize the contents of table records. I'd like to suggest you create a main table to navigation to the sub-level, then you can create query tables to 'reference' main table and add custom navigation step to point to corresponding data tables.

Regards,

Xiaoxin Sheng

[amitchandak]

@VoltesDev , refer to these

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-azure-data-lake-storag...

https://docs.microsoft.com/en-us/power-query/connectors/datalakestorage

https://www.coatesdatastrategies.com/blog/querying-data-in-azure-data-lake-storage-gen-2-from-power-...

[VoltesDev]

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

[Adamtall]

You can combine files with this button

[VoltesDev]

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,

[Adamtall]

Hi,

Follow this steps:

https://docs.microsoft.com/en-us/power-query/connectors/datalakestorage

/Adam