Forum Discussion

3Jk33f3's avatar
3Jk33f3
Icon for Helper I rankHelper 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?

 

  • 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
    Icon for Solution Supplier rankSolution Supplier

    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
      Icon for Helper I rankHelper I

      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.