Forum Discussion
Different amount of rows from same SQL table
I have made a table with some duplicate rows in sql server and import the table into power bi, but couldn't reproduce your issue, duplicate rows still exist in power bi on my side. Could you show a sample of table structure for further analysis?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have made a table with some duplicate rows in sql server and import the table into power bi, but couldn't reproduce your issue, duplicate rows still exist in power bi on my side. Could you show a sample of table structure for further analysis?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
OK, new day and fresh pair of eyes.
The DB structure has changed, and I made the import and query from different databases. The tables were identically named and this lead to my confusion. So everything is working fine, the error code was PEBMAC. :robotlol:
