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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
103 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |