Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
3Jk33f3
Helper I
Helper I

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?

3Jk33f3_0-1691789698398.png

 

1 ACCEPTED SOLUTION

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.

View solution in original post

2 REPLIES 2
Dhairya
Solution Supplier
Solution 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.

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.