Limitations getting Data from Direct Query to Local

Hi Heinrich ,

1. DirectQuery connections can be restricted in the following ways:

Row-level filters applied at the data source level. Row/column limitations in the view/query that the DirectQuery model is based on. Data source may only expose recent data. Power BI itself does not limit DirectQuery by date, but it only queries what is needed for the current visual/page.

2. Verify the True Range of DirectQuery Data

A. Create a summary measure or table. Use DAX to detect the min/max dates in the DirectQuery table.

Min Date = CALCULATE(MIN('Table'[Column]))
Max Date = CALCULATE(MAX('Table'[Column]))

Note: Place this in a card visual or a table to show the actual temporal range of your DirectQuery data.

B. Build a simple DirectQuery matrix

Create a matrix like this: Rows: Year, Month from the date field & Values: Count of rows. It will visually show if older data (e.g. 2024 or pre-May 2025) is missing.

If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

Thank you