Forum Discussion

zraopingm's avatar
zraopingm
Helper IV
1 year ago
Solved

data model only display two tables

Hello, I got into a strange situation. in my current data model, suddenly it only shows two active tables, see image 1. 

it should show all active tables, see image 2. 

I saved a backup file showing all relationships. see image3.

Everything works in the current data model, I can refresh and all reports are working. 

How can I get all relationship back in the current data model.  thank you Zoey

image 1

 

image 2

image3 (back up file)

 

 

 

 

  • Are you looking at the default view of the data model? If you go the data model view you will see some tabs at the bottom, make sure you have All Tables tab selected. 

4 Replies

  • Deku's avatar
    Deku
    Super User

    Are you looking at the default view of the data model? If you go the data model view you will see some tabs at the bottom, make sure you have All Tables tab selected. 

    • zraopingm's avatar
      zraopingm
      Helper IV

      Thank you, yes! it works.. 

      in the model view, i have two tabs. all tables and layout1. 

       

      but what is layout1? it seems the default one you referred to. 

      I am wondering why there is a default view tab in the model view?  

       

       

       

      • Deku's avatar
        Deku
        Super User

        All tables is the one that exists with all power bi reports and can't be deleted. The layout1 was user created