Can't set type to Duration

[PatrikRoos]

Hi

I have o problem with a column that is as standard set to Time. But i have to change it to Duration. The data is looks like this:

But when i change the format to Duration i get an error:

DataFormatError: Can not convert to Duration

Anyone know how to fix this?

Thanks

[v-shex-msft · Accepted solution]

Hi PatrikRoos,

I also can’t reproduce the issue. The Time value can be changed as Duration data type values in query editor. In your scenario, I would suggest you open a new connection to get time data, without apply any other steps, then change its data type to Duration to see if issue occurs. And which region did you set in Power BI Desktop (Options->Regional settings->Locale). And what’s the region of your system which desktop runs on?

If issue persists, would you please share a pbix file with the sample data to reproduce your issue?

Regards,

Xiaoxin Sheng

[ankitpatira]

@PatrikRoos I cannot replicate your issue. Only issue i can think of is that when I convert to type Time, I see data being changed to AM/PM format which doesn't look like in your screenshot so maybe worth looking at why that is not happening. Othersie I have no problems in converting it to Duration type.