Forum Discussion

MelissaSnell's avatar
MelissaSnell
Helper I
10 years ago
Solved

Time Difference Column Works in Power BI Desktop but Gateway Refresh Fails

In the Power BI Desktop Product, if your data contains two date-time columns then within your Query you can select those columns and add a new column that subtracts the two to give you the difference...
Need Help
  • TPalmer's avatar
    TPalmer
    10 years ago

    Unfortunately this is a known issue but there's a straightforward workaround - you can convert the difference column (which is initially a "duration" type) to a decimal or whole number. The bug that olumns of duration type are not currently refreshing in the service is being tracked, but you won't have the same issue with a decimal or whole number column. Let us know if you hit anything else!

TPalmer's avatar
TPalmer
Microsoft Employee
10 years ago

Unfortunately this is a known issue but there's a straightforward workaround - you can convert the difference column (which is initially a "duration" type) to a decimal or whole number. The bug that olumns of duration type are not currently refreshing in the service is being tracked, but you won't have the same issue with a decimal or whole number column. Let us know if you hit anything else!

  • MelissaSnell's avatar
    MelissaSnell
    Helper I
    10 years ago

    Hi there!

    Sorry I didn't reply to your response more promptly, but I didn't seem to receive a notification email - must check my spam setttings!

     

    I will check out your suggestion!