hidden tables and fields are not available in dataflow

[shihabkb]

I am creating DataFlow on the Azure Analysis Service. Some of the tables and fields in some of the tables are hidden. Those tables and fields are not available in the model list when I am trying to add tables to the dataflow. Is it related with my permission? I can see the Hidden tables and fields from my PowerBI desktop. 

For example there a table, REASONS, with fields REASON_ID, REASON_NAME. REASON_ID is a hidded field. Both fields I can see from PowerBI desktop when I select View Hidden option. But the field REASON_ID is not available when I create a Dataflow for the same table.

Table view from powerbi desktop. In this the hidden fields are visible.

Table view from Poser Bi service dataflow creation. Same table, but only Visible columns are available for selection.

Any help will be much appreciated.

[Anonymous]

Hi @shihabkb ,

Which way do you use to create dataflow?

No matter which way, you all need to make sure all table in data source so that you can see the whole content.

Best regards,

Community Support Team Selina zhu

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