Forum Discussion

3Jk33f3's avatar
3Jk33f3
Helper I
3 years ago
Solved

Table is Null in Model View

I'm experiencing some issues when creating measures, the relationships are not being identified. I looked in the model view and noticed that my main tables are coming up null. Does anyone know why? Could this be impacting my creation of measures?

 

Need Help
  • 3Jk33f3's avatar
    3Jk33f3
    3 years ago

    Hi Dhairya - Thank you for replying. Apologies, I got busy at the end of the day and forgot to close this out. The issue was that instead of importing the table from Excel, I imported the tab from the workbook. So PBI was picking up all the blank rows. I fixed it by deleted that table and uploading it again as a table not tab from Excel.

2 Replies

  • Dhairya's avatar
    Dhairya
    Solution Supplier
    3 years ago

    Hey 3Jk33f3 
    Can you please check your data in power query, if there it is showing correctly then it must be error in modelling.

    • 3Jk33f3's avatar
      3Jk33f3
      Helper I
      3 years ago

      Hi Dhairya - Thank you for replying. Apologies, I got busy at the end of the day and forgot to close this out. The issue was that instead of importing the table from Excel, I imported the tab from the workbook. So PBI was picking up all the blank rows. I fixed it by deleted that table and uploading it again as a table not tab from Excel.