How to view dataset hidden fields in excel?

[Anonymous]

1. I have published pbi dataset
2. I succesfully imported it to Excel
3. Problem: how to view hidden tables/fields?

P.S. In Power Bi Desktop version you jus click right mouse button in Dat tab and select "View hidden"

[ibarrau]

Hi. I would say you can't. Power Bi Desktop might allow that becuase it's the main development file in which you build the data model for the first time. You decide to hide something and publish that. The semantic model hosted at Power Bi Service will have the property of the tables hidden because it was set for keeping that way on the server. Power Bi Desktop as the source of everything has the connection to decide. Excel is connecting to the published data model with the hidden setting. You can't change the setting, it was build and deployed like that. If you were connecting the endpoint of the Power Bi Service with any other tool, it's going to be the same as excel, the tables will be hidden. It make sense that works like that. Excel is an exploration of the data model, if the data model has thought to keep that table hidden, it should work like that.

I hope that make sense