Forum Discussion
Solved
Power query - Number.round function works in Power BI Desktop, not in Power BI Services
Hi, I use the function Number.Round in Power query. It works fine when used from Power BI Desktop But when I try to refresh the report in Power BI Services (embedded licence), I get the following e...
Hi SGuichon ,
When I tested with the same query like yours, I got the same error in Power Query Editor:
Try to edit this query when adding the custom column:
#"Added Custom" = Table.AddColumn(#"Filtered Rows1", "Rounded RejectTime", each Number.Round(Number.From([reject_time])*24*60*60)/(24*60*60)),It should work:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi SGuichon ,
When I tested with the same query like yours, I got the same error in Power Query Editor:
Try to edit this query when adding the custom column:
#"Added Custom" = Table.AddColumn(#"Filtered Rows1", "Rounded RejectTime", each Number.Round(Number.From([reject_time])*24*60*60)/(24*60*60)),It should work:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.