cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AbbasG
Helper I
Helper I

Re-naming the columns in BI desktop

Hello People,

 

I need to rename the columns in one report. Without affecting other reports that use the same dataset.

 

So, I have a dataset out of which I have created a number of different reports.

 

The supplier's data in the reports have a Code i.e. Supplier #1 Supplier #2 Supplier #3 and so on in all the reports.

 

Now, I want to show the actual suppliers' name in one of the reports. To do so, I opened the respective .pbix file on the desktop and tried to transform the data. But, It display's me the below message.

 

AbbasG_0-1634281216504.png

 

Any help will be appreciated!

1 ACCEPTED SOLUTION

@AbbasG  Just double click the column name and you can rename it, or Right Click on a column to rename:

 

AllisonKennedy_0-1634283733640.png

 

 

If you need to change the values within a column, you may need to add a table with Supplier ID and Supplier Name columns and relate that to the existing Supplier ID column.


Please @mention me in your reply if you want a response.

Check out my Olympics report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

5 REPLIES 5
AllisonKennedy
Super User
Super User

@AbbasG  You're using a Live Connection to dataset so cannot make any changes. You can swap to Direct Query by clicking that 'Add a local model' button. This will give you some functionality, but you still won't be able to Transform the Dataset queries. You will be able to rename columns now and add SOME DAX (but not All DAX functions are available on Direct Query). 


Please @mention me in your reply if you want a response.

Check out my Olympics report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

@AllisonKennedy Thank you for the response.

 

I have added the local model. Now the storage mode shows as below.

AbbasG_0-1634283519574.png

If you can guide me with the steps to rename the column names. It will be a great help!

@AbbasG  Just double click the column name and you can rename it, or Right Click on a column to rename:

 

AllisonKennedy_0-1634283733640.png

 

 

If you need to change the values within a column, you may need to add a table with Supplier ID and Supplier Name columns and relate that to the existing Supplier ID column.


Please @mention me in your reply if you want a response.

Check out my Olympics report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

@AllisonKennedy It allows me to rename the column. "V name". But I need to change the name for "V1" V2" "V3" and so on.

AbbasG_0-1634284315464.png

I tried to achieve this by "transform data" but it takes me to a blank page as below.

AbbasG_1-1634284393851.png

 

@AbbasG Correct, the best way to rename V1, V2, etc is probably to create a table, then relate it with 1 to many relationship to your table in the existing Dataset using the V Number to the orignal VName column. 

 

V Number V Name
V1 Supplier Name 1
V2 Supplier Name 2
V3 Supplier Name 3

 

Hopefully that makes sense?


Please @mention me in your reply if you want a response.

Check out my Olympics report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!