Hidden columns from a Power BI Semantic Model

[Imre_P]

Hi,

I'd like to Import tables from a Power BI Semantic Model in Power Query so that I can optimize performance later on. 

When Getting the data, I am unable to reference Hidden columns of the model, even if I know their names by looking at them in Power BI Desktop.

How should I reference / unlock using hidden columns when importing in Power Query?

Thanks. 

[v-csrikanth]

Hi @Imre_P 
I wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!

[v-csrikanth]

Hi @Imre_P 
Thank you for being part of the Microsoft Fabric Community.

If you already know the names of the hidden columns, try modifying the M query manually:

1. Get Data from Power BI Semantic Model. Transform data->New Source-> BI Semantic model and connect to the model.

2. Modify the M Query as below:
   Advance Editor
          Table.SelectColumns(Source, {"VisibleColumn1", "HiddenColumn1", "HiddenColumn2"})
   If the hidden columns are available, they will appear in your dataset.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[PImre]

I tried this but the hidden columns were not recognized even if I named them in M. 

[Deku · Accepted solution]

Are you using the analysis services connector? 

Suppling a Dax query should show them

I.e.

Evaluate 

Sales

[PImre]

Thanks! I was not using the Analysis Services connector. This seems like a good starting point.