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 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. 

Need Help

5 Replies

  • Deku's avatar
    Deku
    Super User
    1 year ago

    Are you using the analysis services connector? 

    Suppling a Dax query should show them

     

    I.e.

    Evaluate 

    Sales

    • PImre's avatar
      PImre
      Frequent Visitor
      1 year ago

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

  • 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. 

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

    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!