Data from Azure Data Lake Gen 2 empty

[vilmarci]

I sync the PowerPlatform usage data to an Azure Data Lake Gen2

When I browse in Azure, I can see that for example the powerapps/environments/environments.json file is there and when I download it, it is indeed filled with data about the environments.

In PowerBI desktop, I go to Get Data - Azure Data Lake Gen2, enter the URL and the access key, then I can browse the hierarchy, but I cannot select neither load or transform and also cannot drill down. This applies to all the containers.

If I right click, I can see load and transform, but then I see only empt tables.

This is the query:

let
Source = Cdm.Contents(AzureStorage.DataLake("https://[mystorageaccount].dfs.core.windows.net/", [HierarchicalNavigation = true])),
powerplatform = Source{[Id="powerplatform"]}[Data],
powerapps = powerplatform{[Id="powerapps"]}[Data],
environments1 = powerapps{[Id="environments"]}[Data]
in
environments1

Please advise, what am I doing wrong. Additionally, if there are templates for PowerPlatform dashboards on top of this data lake, any idea is very welcome.

Thanks,

vm

[v-zhangti]

Hi, @vilmarci 

Please check the following link, hope it can help you.

https://community.powerbi.com/t5/Service/Azure-Data-Lake-Gen-2-and-Dataflows/m-p/2472664#M158105 

https://community.powerbi.com/t5/Desktop/Trouble-connecting-to-Azure-Data-Lake-Gen2-data-in-Power-BI... 

https://community.powerbi.com/t5/Desktop/Unable-to-load-data-with-Azure-Data-Lake-Gen-2/m-p/1828144#... 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.