I am trying unsuccessfully to connect though Excel (Power Query) to an Analysis Services tabular model on Azure that has some tables that have been set up as hidden for client tools.
In PowerBI, one has the option to view hidden fields and add them to the report. In Excel, however, I cannot find a similar option and hence I am not able to query the columns in question.
I have tried unsuccessfully edit the M-query, adding the column in question.
Anybody has experience with something similar and can share some advice?