Date Parameter not working as expected

[EduardoCED]

I have a DataSet that has a Date Range Parameter to load the data 
and I have two models in one single dataset 

1 Model is working as expecte If I set the parameter to Todays date the tables are empty (since the last value of received date is today -1) and the load is faster so in server I can set 1 year and load the whole data (Desktop is so slow this is beacuse I sue this date range parameter)

The second model is the same pointeing to different tables but in this case the date range parameter is not working and it doenst matter if I set 1/1/2024 it will load the whole data (20 millons rows) 


any opions of why is this happening?



Model 1 WORKING

MODEL 2 NOT WORKING

[ichavarria]

It's possible that the issue is related to the data type of the date column in your second model. Power BI may not be recognizing the date column as a date data type, which could be causing the date range parameter to not work correctly.

To check the data type of the date column in your second model, go to the "Data" view in Power BI Desktop, select the table that contains the date column, and check the "Data Type" property of the date column in the "Column tools" pane on the right-hand side. If the data type is not set to "Date/Time", you can change it by selecting the column and then choosing "Date/Time" from the "Data Type" dropdown in the "Modeling" tab of the ribbon.

If the data type of the date column is already set to "Date/Time", another possibility is that there is a problem with the query that is being generated for the second model when you apply the date range parameter. You can try modifying the query manually to include a filter on the date column that corresponds to the date range parameter. To do this, go to the "Transform Data" view in Power BI Desktop, select the table that contains the date column, and click the "Filter Rows" dropdown in the "Transform" tab of the ribbon. From there, you can add a filter that restricts the date column to values within the selected date range. Once you've made the filter, you can click "Close & Apply" to apply the filter and load the data into your second model.

Best regards, 

Isaac Chavarria

If I answered your question, mark it as a solution.