Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I
Helper I

Date Parameter not working as expected

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?







Solution Specialist
Solution Specialist

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. 

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors