Dates are not showing beyond FY 2023

[Nile]

Hi, when importing data from SQL service, dates are not going beyond FY 2023.  

Thanks Nile

[Anonymous]

Hi @Nile ,

What's your connection mode? 

This issue could be due to a limitation of DirectQuery connections in Power BI Desktop. There's a limit of 1 million rows can return on any query. 

DirectQuery in Power BI - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Nile]

Thanks Stephen, you are right.  However, on investigating the filters, while importing, I found that FY beyond 2023 was not selected, so as per my need I unticked this filter.

Thanks Najam