cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Johan-MTM
Helper III
Helper III

Renaming columns cause error

Hi!

When I rename a column in a dataset by rightclicking:

JohanMTM_0-1692790165346.png

 

all reports build from that dataset that use the column will show an error:

JohanMTM_1-1692790245911.png

 

is there a workaroud for this? Its to much work to go into each report and make the changes there, it would be so much easier to do it in the dataset that all reports are build from. is it possible?

 

Thanks

1 ACCEPTED SOLUTION
HarishKM
Impactful Individual
Impactful Individual

@Johan-MTM  Hello,
you can go to transform data and then applied step to remove rename colomn step then close and apply to see the changes.

HarishKM_0-1692860710945.png

 

option 2- if name has been change in dataset then you can update column in name in change type. it will look like this.

HarishKM_1-1692860814383.png

 

 

Thanks 

Harish M.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

6 REPLIES 6
Johan-MTM
Helper III
Helper III

Hi all,
@HarishKM kindly helped me over a Teams-call. Turns out its working as intended. I have a live reports, so if i change the name of a table in the base report I have to chnage it manually in my other reports.

HarishKM
Impactful Individual
Impactful Individual

@Johan-MTM  Hello,
you can go to transform data and then applied step to remove rename colomn step then close and apply to see the changes.

HarishKM_0-1692860710945.png

 

option 2- if name has been change in dataset then you can update column in name in change type. it will look like this.

HarishKM_1-1692860814383.png

 

 

Thanks 

Harish M.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Hi,

Than you for you sugestion but it didn't help. 
Here is what I did:
I opened this dataset that all my reports are based from:

JohanMTM_0-1693309984159.png

 

I changed media_typ to Medietyp in Transform data, and save/apply:

JohanMTM_1-1693310081983.png

If i then open one of the reports (after refresh is done):

JohanMTM_2-1693310152328.png


The tablename is changed but I get the same error: 

JohanMTM_3-1693310302712.png

So the reports that are based on this dataset and uses Medietyp/media_type now shows the error.

Any ideas?

HarishKM
Impactful Individual
Impactful Individual

@Johan-MTM Hello,
Can you try to investigate each applied step in power query to check where were you getting error.

 

 

Thanks

Harish M

Thank you! I will try this when I'm back at work after the weekend!

Johan-MTM
Helper III
Helper III

Hi, 
Maybe this should have been posted in Desktop section. Anyway, I've search other post and I just would like a confirmation that it's not possible to make a change in the dataset and have all reports build from that dataset automatically have the same changes done? Is it only possible with a 3rd party application?

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors