Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Aman-K
Helper III
Helper III

Add another column from the source in Data table

Hi All,

 

I have created reports in Power BI and the data is coming from Jira. I have to create a new report which will look for the "Component" field and give the number of tickets per component. Now the data table I got hasb't got that field as when I tidied up the data in the table then I deleted a lot of fields which didn't make any sense to me that time . Now I have to add a field from the source but I don't want to start from the scratch again as I have built quite a few reports already. 

Can anyone please let me know if it's possible to add a field from the source in the data table ?If yes then how this can be achieved?

Any help will be much appreciated!

Thanks

 

 

1 ACCEPTED SOLUTION

Great, Thanks TomasAndersson .

View solution in original post

2 REPLIES 2
TomasAndersson
Solution Sage
Solution Sage

Hi!
If you go to your dataset and under "More options" select "Edit query" next to your table, you should be able to see what steps you applied when you cleaned the data. There you should be able to change the steps, for example by "undeleting" a column you previously deleted.

Hope this helps! If not, you can try share some screenshots of how your data and query looks so you can get more specific help.

TomasAndersson_0-1681995580381.png

 

 

TomasAndersson_1-1681995615700.png

 

 

Great, Thanks TomasAndersson .

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors