Forum Discussion
Power BI Publisher for Excel transforms values into text
I have several calculated columns (decimal-type) in PBI, which work well when I create PBI reports. When I connect to Excel using "Connect to Data" the numbers convert to text, and manipulating/ranki...
Well that certainly sounds like a bug then. You should report it
I have the same problem. Also if I transform explicitly the type via power query to Type.Int64 it will be handled in the data modell like text.
Is there anysolution
Thanks