Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Renaming table and fields in Power Bi Dataset without causing any problem

Hello, I have a Power BI dataset built on the concept of a star schema that draws its source from a series of SQL Server views. Initially, I named them all Dim_Calendar, Dim_Company, Dim_Client, Fac...
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    Based on my test, when we change the dataset tables name in PowerBI desktop, the visual will not be affected, then we can re-publish it to PowerBI Service.

     


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Anonymous ;

I don't quite understand what you mean, is the column name of the data set changed? I don't seem to have that option.


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello, if you go to the Schema section of the dataset, and you right click on the field on a table, you can rename there.

 

 

Actually, I'm doing a field refactoring from my SQL Server source so I decided to get around the problem of having to rename fields in my dataset. After the refresh, the field names are automatically updated.

 

Now it remains to be seen what behavior the dataset will have on connections in Microsoft Excel.