What’s happening
When loading data into Power BI or Excel using Power Query, some values appear incorrect, misformatted, or inconsistent compared to the CSV export.
Why this happens
Power Query may not correctly detect data types when importing the source, which can lead to formatting or interpretation issues.
How to fix it
Fix incorrect QuoteStyle setting in Power Query
Cause: Power Query is using an incorrect QuoteStyle setting when reading the data source.
Fix:
Open Power Query
Select the Source step
Locate the setting:
QuoteStyle=QuoteStyle.NoneChange it to:
QuoteStyle=QuoteStyle.Csv
If the issue continues
Recheck the Source step configuration
Confirm the data loads correctly after applying the change
Review the query for any additional transformations affecting data formatting