Forum Discussion

NidhiBhusari's avatar
NidhiBhusari
Helper IV
4 years ago
Solved

replacing source file having different column names.

Hi , I am replacing a .csv file with a SQL Table in Power BI. I have replaced it without issues. However, the column names are different between the .csv file and SQL Table. Also I should not rename...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi NidhiBhusari,

    If you are working with SQL data source, you can enable the advanced option to write t-SQL statement to do rename operations on the result tables. AFAIK, these operations work on the return data and do not affect the database table structures.

    Power Query SQL Server connector - Power Query | Microsoft Docs
    Regards,

    Xiaoxin Sheng

NidhiBhusari's avatar
NidhiBhusari
Helper IV
4 years ago

Hi amitchandak ,

I have a Power BI Table which has a .csv file as Data Source.
It has columns: Customer ID, Date, Sales, UnitsI am now replacing this with a SQL Table with columns as : cm_id, t_date, revenue, qtyI now want to ensure my visuals don't get errors also I don't want to rename cm_id to Customer ID
 
 
 
 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi NidhiBhusari,

If you are working with SQL data source, you can enable the advanced option to write t-SQL statement to do rename operations on the result tables. AFAIK, these operations work on the return data and do not affect the database table structures.

Power Query SQL Server connector - Power Query | Microsoft Docs
Regards,

Xiaoxin Sheng