Forum Discussion

sirros_iot's avatar
sirros_iot
Helper III
8 years ago

Data modeling by Push Streaming

Hello all!

I'm getting the data by Push Streaming dataset and I need my datetime colomn in 24h, but the Power BI convert 24h into 12h mode.

This is in my REST API on Power BI service.

[
        {
             "id" :"AAAAA555555",
             "sensor" :"AAAAA555555",
             "ciclos" :98.6,
             "contagem" :98.6,
             "pares" :98.6,
             "_ts" :98.6,
             "_at" :98.6,
             "now" :"2018-06-12T18:23:29.715Z",
             "intervalo" :98.6
       }
]
The value "now" is supposed to be on 24h mode but the Power BI changes it.
Why does the Power BI Desktop changes it? How I can stop Power BI Desktop of changing the data type?

Sorry anything, thanks
Diego
Need Help

4 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi sirros_iot,

     

    Please check if the date format of system is 12h or 24h, if the issue still occurs, click file->options->region and then change the region to US and try again.

     

    Regards,

    Jimmy Tao

    • sirros_iot's avatar
      sirros_iot
      Helper III
      8 years ago

      Thank you for the answer v-yuta-msft,

      I changed the Power BI software language but it didn't solve my issue..
      I will see if changing Power BI service language can help me.

      I'll reply if I get that right

      Best Regards,
      Diego