Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
Solved! Go to 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.
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 35 | |
| 34 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 136 | |
| 102 | |
| 68 | |
| 66 | |
| 58 |