Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sirros_iot
Helper IV
Helper IV

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
4 REPLIES 4
v-yuta-msft
Community Support
Community Support

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

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

Hi sirros_iot,

 

Have you solved your issue by now?

 

Regards,

Jimmy Tao

Hi @v-yuta-msft

Thanks for the reply, I changed the data connection, and then it started working. Do you think it would be good to accept your reply as solution?

Best Regards,
Diego

Helpful resources

Announcements
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors