We don't support the option 'HierarchicalNavigation'. Parameter name: HierarchicalNavigation

[Anonymous]

Hi. 

Getting this error message when trying to load a table into power bi desktop.

Using the ADLS Gen2 CDM Folder View. 

Anything I'm missing that should be turned on or something to allow loading this into my model?

Thanks!

[amitchandak]

@Anonymous , you are trying this first time. or it worked previously and not now.

There are some issue reported with August 2020 update -https://community.powerbi.com/t5/Issues/idb-p/Issues

But make sure that is because of the new update, setup is correct

refer

https://powerbi.microsoft.com/es-es/blog/power-bi-dataflows-and-azure-data-lake-storage-gen2-integration-preview/

https://www.sqlbi.com/blog/marco/2020/05/29/optimizing-access-to-azure-data-lake-storage-adls-gen-2-in-power-query/

[Anonymous]

Hi @amitchandak 

This is the first time I'm using the CDM method, but I have connected to ADLS Gen2 without problems before. 

[amitchandak]

@Anonymous , Update this ticket - with your issue -https://community.powerbi.com/t5/Issues/August-2020-version-of-PBI-Desktop-corrupts-any-PBIX-report-file/idi-p/1285567

Let us check with other super users on this issue

@Greg_Deckler , @parry2k , @ImkeF , can you help on this error

[Greg_Deckler]

Seems like this issue might have started with the June version:

https://community.powerbi.com/t5/Desktop/Hierarchical-Navigation-June-2020-release-of-Power-BI-Deskt...

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[genegc · Accepted solution]

It looks like the problem began with the July release, not June. I've also confirmed that the problem exists in the August release.

I downgraded to the June release and it resolved the problem for me.