I have a user who has created a report in Desktop that uses an Excel file in SharePoint as it's source. The field in Excel is formatted as text because it contains mixed values (one row is a percent (displayed as 45%) the next is a decimal value (displayed as 0.14). It is being formatted in Power Query and in the desktop as text and reads correctly in the visual. However, when the data is refreshed through a Schedule Refresh the decimal values are expressed to a high level of significant figures (for example 0.14000000001). Is this a known issue? I can't find anything online about it. The only way we seemed to be able to get resolution was to explicitly tag the data in Excel using the ' character ('45%, '0.14) but that is not a good fix as these files will be updated by users who may not realize they need to add the prefix character.