Power BI Model - Fabric

Hi Sanju_BI ,

It looks like you've updated the data type of the date_entered field from DateTime to Date in your Fabric Semantic Model, but Power BI Desktop is still displaying it as DateTime even after refreshing. This issue might be caused by metadata caching or an incomplete update in Power BI.

One approach to resolving this is to refresh the metadata in Power BI Desktop. Open Power Query Editor (Transform Data), click Refresh Preview, and then close and apply changes. If the issue persists, clearing Power BI’s cache might help. Navigate to File > Options and Settings > Options, go to Data Load, click Clear Cache, and restart Power BI Desktop before refreshing the dataset.

Another way to force Power BI to recognize the change is to disconnect and reconnect to the Fabric Semantic Model. Remove the connection to your model, reconnect, and verify whether the date_entered field is now recognized as a Date instead of DateTime.

It is also important to ensure that the data type change was saved properly in Fabric. Open Fabric, check the date_entered field, confirm it is set to Date, save the semantic model, and then refresh Power BI.

Additionally, check if the relationship between date_entered and your Date table remains valid. Open Manage Relationships in Power BI, verify that the field is correctly mapped, and if necessary, delete and recreate the relationship.

If Power BI still does not reflect the change, you may try manually updating the field’s type in the Model view. Open Model View, find the date_entered field, and change its type to Date.

If modifying the field manually is not an option, another method is to create a new calculated column to convert date_entered into a pure date format using a DAX formula:

date_entered_fixed = DATE(YEAR('Table'[date_entered]), MONTH('Table'[date_entered]), DAY('Table'[date_entered]))

Alternatively, you can use Power Query to transform the column by removing the time portion:

Table.TransformColumns(Source, {{"date_entered", each Date.From(_), type date}})

After applying these changes, refresh Power BI and check if the issue is resolved. If none of these steps work, the problem may be related to an outdated connection or semantic model refresh delay in Fabric. You may try publishing the model again and ensuring it is fully refreshed before reconnecting to Power BI.

Best regards,