Forum Discussion
AsafPinhas
3 years agoRegular Visitor
Data Difference Between Desktop and Service
I'm using data import from Azure SQL server and have decimal numbers stored as text. in Power Query i'm converting the text to number and then created measures based on these fields. While using de...
Anonymous
3 years agoNot applicable
Hi AsafPinhas
1.Perhaps you can try to convert the type on the database side now.
2.You can aggregate the data in Power Query first, then create a calculated column to quate these data, then set the type of the calculated column.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.