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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi VegarOyfoss ，

First, could you please try to click Refresh and check whether you can get the "full" data load from SQL database? If still not, could you please provide the related SQL query and the applied codes of the query finally generated in Power Query Editor in order to make troubleshooting to further check your problem? Have you applied any date filter or refer multiple tables in your SQL query?

Best Regards