Forum Discussion
Long ID number rounding
Hi lawsonbe
I confirm the problem and created an issue here https://community.powerbi.com/t5/Issues/Unexpected-long-numbers-round-in-Table-visual/idi-p/1082517#M56541. you can vote for
But solution in your case is to change date type to string in Power QUery mode, it helped me
In the main report view, click on the column in the fields panel and the Column Tools tab. Make sure the format shows as Whole Number and not Scientific (and the that column isn't being aggregated).
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
That doesn't seem to make a difference.
Here is the Report view
Here is the table view
Hi lawsonbe
I confirm the problem and created an issue here https://community.powerbi.com/t5/Issues/Unexpected-long-numbers-round-in-Table-visual/idi-p/1082517#M56541. you can vote for
But solution in your case is to change date type to string in Power QUery mode, it helped me
- lawsonbe
Can you confirm that is issue have been resolved as I am also struggling with the same issue 😞I am not working in that dataset any longer and can't confirm that it has been corrected. If you are still seeing the same behavior, it is safe to say it is not. Changing the field to Text is your only option.
