A confirmation code will be emailed when setting up your account or resetting your password—check spam if needed.no-reply@dynamicscommunities.com

Date inconsistencies

  • Power Platform

    Date inconsistencies

    Posted by DSC Communities on April 30, 2020 at 12:51 am

    • Gerry Miller

      Member

      April 30, 2020 at 12:51 AM

      Hi,

      I am encountering an issue when publishing reports to Power Bi Service in that when I want filter by date the calendar comes back with different dates. As you can see from the attached screenshot,  I wanted to filter records between 14/04/2020 and 15/04/2020 (format DD/MM/YYYY). but the calendar returns 02/04/2021 to 03/04/2021.  Not a timezone issue but possibly a formatting issue. Can anyone tell me what to do to reconcile the formats on Power BI Desktop and Service?

      Regards

      Gerry

      ——————————
      Gerry Miller
      Oracle DBA
      Brisbane
      ——————————

    • Audrey Abbey

      Member

      April 30, 2020 at 4:11 PM

      Looks like regional settings in Power BI or your Browser are set to US date format or something?
      Since there is no month 14, it is trying to translate and failing hard. 

      here is a link. Let me know if that doesn’t fix it because this is super duper weird. 
      https://docs.microsoft.com/en-us/power-bi/supported-languages-countries-regions

      ——————————
      Audrey Abbey
      SR. BI Developer/Analyst
      LeapFrogBI
      Portland OR
      ——————————
      ——————————————-

    • Gerry Miller

      Member

      May 1, 2020 at 2:00 AM

      ?Thanks Audrey.  It was the Language in ‘Settings’, which was set to ‘Default’. I set it to ‘English’ and all is working correctly now.

      Regards

      Gerry

      ——————————
      Gerry Miller
      Oracle DBA
      Brisbane
      ——————————
      ——————————————-

    DSC Communities replied 5 years, 6 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Date inconsistencies’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!