Get Data from Azure Data Lake Sore Gen2 (Not Dataflow)

[admin_xlsior]

Hello,

When using the new feature to Get Data - Azure Data Lake Store Gen2, I realize I have to put the URL Path same as the URL Path when we connect it from Power BI Dataflow (which is on PBI Service side)

This is the (only) input after we choose the Get Data feature:

And this is the input if we Add CDM folder within Power BI Dataflow in PBI Services :

In above screen, they give us a clue on how the path should be, which is we need to put the model.json file path.

When we take a look at the our data in ADLSg2 of Azure portal which created from Power BI Services Dataflow process, they have that file, so I can go to it's properties and just copy it. 

My question is, if for example we have our own data, in their own separate CDM folder in the same Data Lake Store, but it is not from Power BI Service Dataflow, lets say from Azure Data Factory process, how to have this model.json file ?

I hope I can describe clear enough for this scenario. 

So basically I want to access my CDM folder (ADLSg2 data) using the Get Data feature in Power BI Dekstop, but for now I don't have that model.json file in my CDM folder.

Any advice on this case?

Thanks in advance.

[v-piga-msft]

Hi @admin_xlsior ,

I have not tried connect with Azure Data Lake Store Gen2 connector without Dataflow in power bi desktop.

You may could try connect it with Azure Data Lake Store REST API.

In addition, you could refer to the comment of Kanad Chatterjee which should be helpful.

Best  Regards,

Cherry

[admin_xlsior · Accepted solution]

Hi Thanks,

I think I found the solution already. It turns out, we don't need "model.json" when using this new feature to connect to ADLSg2.

Just put the full URL up to filename path. So for example if I have subfolder \ExternalDB then the file is customer.csv, I just put the URL like this :

https://mydatalake.dfs.core.windows.net/powerbi/ExternalDB\customer.csv

The problem is only I need to give acess one by one per file in Azure Storage Explorer. It is quite tedious.

Thanks,

[v-piga-msft]

Hi @admin_xlsior ,

Glad to hear the issue is resolved,  you can accept your reply as solution, that way, other community members would benefit from your solution.

Best Regards,

Cherry

[admin_xlsior]

Hi actually not really solved in a way, I need to give access the file one by one. What if I have thousands ?

Thanks,