Forum Discussion
Mapping data from SQL server to existing tables
Hi sleepyhedgehog ,
Q1. Yes, you need to make sure the field name in the dataset is the same as the field name in SQL Server. If different, the following error will be prompted when refreshing.
Q2. I noticed that you want to change the field name in the data source. Power BI does not support reverse editing of the data source, so you may need to go back to the data source, use GUI tools or enter SQL statements to change the column names.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi sleepyhedgehog ,
Q1. Yes, you need to make sure the field name in the dataset is the same as the field name in SQL Server. If different, the following error will be prompted when refreshing.
Q2. I noticed that you want to change the field name in the data source. Power BI does not support reverse editing of the data source, so you may need to go back to the data source, use GUI tools or enter SQL statements to change the column names.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data