CSV Export from SQL Server Does Not Include Column Headers

Rufyda This is not a Power BI / Fabric issue. It comes from how the CSV is being generated from SQL Server.

Recommended approaches

1. Do not export to CSV manually
Best practice is to connect Fabric / Power BI directly to SQL Server:

• Use SQL Server connector

• Use a view or native SQL query
  This preserves column names and data types automatically.

2. If you must generate a CSV, use a tool that includes headers
SSMS “Save Results As CSV” does not reliably include headers.

Better options:

• bcp with -h option

• sqlcmd with headers enabled

• SSIS or Fabric Data Factory pipeline

Example (sqlcmd):

sqlcmd -S ServerName -d DatabaseName -Q "SELECT ..." -s "," -W -o output.csv

3. Use Fabric Data Factory / Pipelines
Recommended Fabric-native solution:

• Source: SQL Server

• Sink: Lakehouse / Files (CSV)

• Enable “First row as header”
  This guarantees headers and avoids CSV issues entirely.

4. Power BI workaround (not ideal)
In Power Query:

• Manually promote first row to headers
  This only works if the first row actually contains column names.

Thank you to everyone for the helpful suggestions 🙏

I wanted to share the final resolution in case someone else faces the same issue.
The problem was not related to Power BI or Microsoft Fabric, but rather to SSMS settings.

In SQL Server Management Studio (SSMS), when exporting query results to CSV:

Go to Tools → Options

Then Query Results → SQL Server → Results to Grid / Results to Text

Enable “Include column headers when copying or saving the results”

After enabling this option, the exported CSV file included the column headers correctly, and Power BI / Fabric recognized the columns without any issues.

Hope this helps someone facing the same problem 👍