cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vind1989
Helper II
Helper II

SQL query data different in PQ

Hi all,

 

I have a SQL query that when I load into PQ untouched is showing different results then what SSMS is showing. Is there a setting or something simple causing this?


Thank you! 

3 REPLIES 3
v-luwang-msft
Community Support
Community Support

Hi @Vind1989 ,

Try to  reinstalling PBI.This solution comes from the same problem in the link.

And you could refer the below:

And if question still not solved ,could you pls show the detail picture of different ?And remove confidential data.
 
Did I answer your question? Mark my post as a solution!
 
Best Regards
Lucien
amitchandak
Super User
Super User

@Vind1989 , power query shows sample 1000 record. Order can be different but should show them correctly.

If you have more than 1000 records. check in data view.

 

If less than that, then check for any datatype issue or error rows

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

@amitchandak  as a test i limited the sql query to 2 records and when I put the same query in powerbi only one of the records populate 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors