HELP: Power Query changing the numbers inflating them

Hi there,

Something peculiar is happening with Power Query. I have a number, which says 2,3 hours. When I bring it to the Front end(model) it inflates the number in excel and in Power BI.

Power Query

Copied from Power Query to Excel


Branch Sales.pbix (956.0 KB)
22_01_Branch offline data.xlsx (33.5 KB)
22_02_Branch offline data.xlsx (28.1 KB)
22_03_Branch offline data.xlsx (29.0 KB)
22_04_Branch offline data.xlsx (33.7 KB)
22_06_Branch offline data.xlsx (27.4 KB)
22_07_Branch offline data.xlsx (39.4 KB)
22_08_Branch offline data.xlsx (26.0 KB)
22_01_Major Incidents.xlsx (1.0 MB)
22_02_Major Incidents.xlsx (1.1 MB)
22_03_Major Incidents.xlsx (1.2 MB)
22_04_Major Incidents.xlsx (1.3 MB)
22_05_Major Incidents.xlsx (1.4 MB)
22_06_Major Incidents.xlsx (1.5 MB)
22_07_Major Incidents.xlsx (1.5 MB)
22_08_Major Incidents.xlsx (1.6 MB)
22_01_Power Outage.xlsx (17.9 KB)
22_02_Power Outage.xlsx (20.2 KB)
22_03_Power Outage.xlsx (29.9 KB)
22_04_Power Outage.xlsx (32.4 KB)
22_05_Power Outage.xlsx (19.9 KB)
22_05_Power Outage.xlsx (19.9 KB)
22_06_Power Outage.xlsx (38.4 KB)
22_07_Power Outage.xlsx (60.4 KB)
22_08_Power Outage.xlsx (25.2 KB)
22_01_Protest Action.xlsx (16.6 KB)
22_02_Protest Action.xlsx (15.4 KB)
22_03_Protest Action.xlsx (15.4 KB)
22_04_Protest Action.xlsx (16.4 KB)
22_05_Protest Action.xlsx (14.9 KB)
22_06_Protest Action.xlsx (15.8 KB)
22_07_Protest Action.xlsx (16.3 KB)
22_08_Protest Action.xlsx (18.5 KB)
Holidays.xlsx (14.1 KB)
Sites.xlsx (63.4 KB)

Bumping this post for more visibility from our experts and users.

Hi @SammiP - I am not able to replicate the issue at my end. I am getting same value if copying from PO and duration if copying from Activities.

Ankit J

Thanks, @ankit for providing your insight about this inquiry.

Hi @SammiP,

Just checking if you still require assistance with regard to this inquiry.

Thank you!

Hi @SammiP

Due to inactivity, a response on this post has been tagged as “Solution”.

If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

We request you to kindly take time to answer the Enterprise DNA Forum User Experience Survey,.

We hope you’ll give your insights on how we can further improve the Support forum. Thanks!