Data from Azure Data Lake Gen 2 empty

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