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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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