Forum Discussion

VegarOyfoss's avatar
VegarOyfoss
Icon for Helper II rankHelper II
5 years ago

Power BI not loading all data from SQL Query

Hi All   Has anyone alese noticed cases where Power BI January 2021 does not load all data from  SQL query? In SSMS I am getting 405 results, but when I use the EXACT same query in Power BI, it on...
Need Help
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

hi VegarOyfoss ,

 

Where you are seeing these total rowss of 389? Is it in Power Query Editor? Have you scrolled to the bottom and confirmed that the rows are less. 

One thing what you can try is add an INDEX column in your dataset (start from 1) then check how many rows are coming up in Power BI.

 

Thanks,

Pragati

  • VegarOyfoss's avatar
    VegarOyfoss
    Icon for Helper II rankHelper II
    5 years ago

    Pragati11 

    I see them in the Power Query Editor by scrolling down and looking at the index, in the Data window AND by downloading the data to excel through PowerBI. I am 100% sure I only have 389 rows, my problem is understanding why

    • TCox's avatar
      TCox
      Regular Visitor
      3 years ago

      I'm running into this issue too. I know this post is old but curious if you found an answer.