Forum Discussion

whaz's avatar
whaz
Frequent Visitor
7 years ago
Solved

Have to enable 'Show Items with no data'?

 

 

We have a SSAS tablular data model used for Power BI.  When I use fields from a different table that have null values I have to enable 'Show items with no data' so all records are visible.  Being new to Power BI and more familiar with relational data models, it seems non-intuitive to me that I have to enable an option to show records with null values. 

 

Is this a design flaw with the data model, or as it is a tabular data model this is expected behaviour?  What is best practice for the design of data models in this regard.

 

 

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support

    Hi whaz 

    Hope this offical document helps.

    Show items with no data in Power BI

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support

    Hi whaz 

    Is this problem sloved?

    If not, please let me know.

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.