Skip to main content

Power BI/Excel data doesn't look the same as CSV Export

Jasvir avatar
Written by Jasvir
Updated over 10 months ago

Sometimes Power Query does not detect the data types correctly resulting in data not appearing correctly inside of Power BI/Excel.

To resolve this

  1. Open Power Query

  2. Click the Source step

  3. Change the Quotestyle=Quotestyle.None to Quotestyle=Quotestyle.Csv

Did this answer your question?