Forum Discussion

Imre_P's avatar
Imre_P
New Member
1 year ago
Solved

Hidden columns from a Power BI Semantic Model

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...
Need Help
  • Deku's avatar
    Deku
    1 year ago

    Are you using the analysis services connector? 

    Suppling a Dax query should show them

     

    I.e.

    Evaluate 

    Sales

v-csrikanth's avatar
v-csrikanth
Community Support
1 year ago

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's avatar
PImre
Frequent Visitor
1 year ago

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