Only the first 1000 rows is loaded into the Data model

[NiklasAlmen]

Hi!
I use a Azure SQL database connector to load (Import Mode) our DimDate table where we have all dates reprecented in the year 2010, 2021 and 2022.

When I load this table into the model I only get the first 1000 rows (Min date = 2020-01-01 and Max date = 2022-09-26)
In Power BI Desktop - When i sort the date column (desc) i get 2022-09-26. 

When I look in Power Query and sort the date column (desc) i get as expected 2022-12-31 (or aquivalent 31/12/2022). 

If I then Close and apply i get the following result in the data model,

and if I then sort the date column (ascending) I get the "min" date 2020-04-06 which proves I only get the first 1000 rows,

I have tried 4 different connectors that give me the same result. 
I have also tried the Table.Buffer() function that was suggested in a similar issue in 2018 but it doesn´t sort out this issue. 

I use the 2021 Oct version of Desktop,

Thank you! 

[Greg_Deckler]

@NiklasAlmen Paste your code from Advanced Editor. Could be an issue with the View or Stored Procedure you are pulling from limiting it to 1000 rows.

[NiklasAlmen]

Thank you for the reply @Greg_Deckler!
Here you have a snapshot of the M code, 

If I do a select * from the view in the database I get the expected result and due to that I also get the expected result (all dates in the mentioned years) I had basically ruled out the option that it could have something to do with the backend.

[Greg_Deckler]

@NiklasAlmen Well, 1000 is the default amount of rows pulled for preview purposes in Power Query Editor but that should go away and all rows should load once you load the data. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[NiklasAlmen]

Thanks @Greg_Deckler!
I have created a support ticket and talked to the support team yesterday, and they are looking in to it.

Thanks for your support! 

[greggbb]

@NiklasAlmen Did you ever solve this issue?  I am now encountering the same problem.

Thanks!