Date/Time Parameter drops Time portion of the string

[kg_iconic]

I'm setting up a pair of parameters that are set to Date/Time. However, whenever I put a string in like 1/1/2024 12:00:00 AM and navigate away from the parameter (either to another parameter or by clicking ok), it automatically truncates my entry to just the date with a trailing space (ie. 1/01/2024 ) 

The parameter works and acts just fine on a colleagues machine, but refuses to on mine. I've checked all the regional settings and everything looks very standard. I've made sure I'm up to date. What am I missing here? 

Thank you in advance!

[v-achippa]

Hi @kg_iconic,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @govind_021 for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @kg_iconic,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided or by the super user resolved your issue?
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @kg_iconic,

We wanted to kindly follow up to check if the solution I have provided or by the super user resolved your issue?
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[govind_021]

Hi @kg_iconic 

It sounds like the issue might be related to local settings or software configurations. Here are a few things you can check:

1. Regional & Language Settings: Even if they seem standard, compare them with your colleague's settings to ensure there are no differences in date/time formats.

2. Power BI Version: Since it works fine on your colleague’s machine, verify that both of you are on the same Power BI version. If not, try updating to the latest version.

3. Data Type in Parameter Settings: Double-check that the parameter is explicitly set to "Date/Time" rather than just "Date." Sometimes, even small changes in data type can cause this behavior.

4. Formatting in Source Data: If your parameter is pulling from an external source (e.g., Excel, SQL), check whether the data format includes the time portion properly.

5. Clearing Cache & Restarting: Try clearing Power BI's cache and restarting the application to see if it resolves the issue.

6. Test on a New File: Create a new Power BI file and set up the same parameter from scratch. If it works fine there, the issue might be specific to your existing PBIX file.
   
   Best Regards
   Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , DP 600 Certified Fabric Analytics Enginner )
   Let's Connect
   Linkdin - www.linkedin.com/in/govind-sapkade-845104225
   Youtube - http://www.youtube.com/@govind_dataanalyst

[kg_iconic]

I've attempted all of these steps and to no success. 

[OwenAuger · Accepted solution]

@kg_iconic 

Out of interest, are you still having an issue with this parameter?

Here are a few things I would check if I were debugging this.

1. Does the parameter behave as a valid datetime value when referenced by other queries?

2. Could you post a screenshot of the Manage Parameter dialog box and the M code from Advanced Editor? I would expect something like below (with possible differences due to regional settings):

#datetime(2024, 1, 1, 0, 0, 0) meta [IsParameterQuery=true, Type="DateTime", IsParameterQueryRequired=true]

3. If you create another query by referencing the parameter directly, does it show the expected datetime value, similar to this?

4. If you create another query to inspect the parameter's type, e.g. = Value.Type(Parameter), does it show datetime, similar to this?

I've attached my PBIX in case that helps in any way.

[v-achippa]

Hi @kg_iconic,

Thank you for trying the suggested steps, 

• Once check the Default Date formatting in Regional settings in power bi, temporarily switch the Local and restart the power bi and check if the issue persists.
• Even though regional settings are fine some applications override them, so check the system level Date/Time formats and compare with your colleague’s system and make changes accordingly.
• If possible i request you to please try the same PBIX file on a third machine to compare behavior, if the issue is still occurring.

If the issue persists, please check for any error messages and if possible please share the pbix file. let us know if you need any further assistance.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa