Forum Discussion
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
Hi Heinrich ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Thank you.
Hello v-dineshya
Hello pankajnamekar25
Thank you very much for your detailed reply it is very kind
Solution 1: Is not possible as we do not have the licences
Solution 2: I created a 2nd table in Import Mode. But I start to believe that the data is from 2025 and not from 2024 and from this June and not May as it is shown. Because, when I look at the days and month they procceed and there are only last and few data.
Is it possible that data in direct query is limited and changed.
I am not in control of the Direct Query Database.
How can I check for these?
Regards
Heinrich
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
Hi Heinrich ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Thank you.
Hi @Heinrich ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Thank you.