Forum Discussion
Visualization/query not read all rows of table
Hi all,
A table with 807 rows is imported correctly ( as I see all values in the "Data" view), but when I tried to build any visualization, only 247 rows seem being read, as I simply created a measure to count the nombre of rows in the table.
None complex transformation done yet, only import the table from a excel.
Anybody has had the same issue?
Very strange, cannot figure it out.... 😖
Hi all,
I fixed it!
It looks like an intermediate table that I connected it through (by accident ) filtered out some rows. I am still pretty new to Power BI and relational databases. I guess the lesson is.
thank you all!
4 Replies
Hi all,
I fixed it!
It looks like an intermediate table that I connected it through (by accident ) filtered out some rows. I am still pretty new to Power BI and relational databases. I guess the lesson is.
thank you all!
- ChrisMendoza
Resident Rockstar
What does COUNTROWS(asset) return?
COUNTROWS(asset) returns 249 as nbr of rows
Hi DanZ ,
Glad to know your issue has been solved by yourself, please Accept your last reply as the solution to make the thread closed. More people will benefit from it. Thanks😀
Best Regards,
Eyelyn Qin
