Forum Discussion
Row_Number() works in SMSS, but creates two rows when the data comes into Power BI
I use the following in smss: Select Row_Number() over(partition by .Location,SKU order by Location,SKU) as RN. In SMSS I get one row per SKU by location, but when I use the exact same query in P...
BA_Pete
Super User
Super UserHi stephenstill ,
Highly unlikely this is a bug in PQ.
If you use the native query method of importing data, PQ just shows the data that the server returns, exactly the same as SSMS does.
There might be ways to merge the rows but I'd not recommend doing that. You really need to identify what the actual issue is and resolve that in order to maintain data integrity.
Pete