cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Power BI Desktop - set fields for csv export using see records

Hi everyone,

 

I'm using Power BI Desktop. I have a number of visualisations. A number of them use the column/bar charts.

 

For example, I may have a bar graph showing the number of support tickets open in each support team.

 

To dig deeper, we will right click a bar graph for a support group and click "See Records". On the next screen, you can see your rows of data and have the ability to order your data columns, add/remove columns and then export to CSV.

 

I do this practice daily.

 

Is there a way to default a list of columns and their order when clicking "See Records". Any changes made revert when you check the data next time. 

 

Alternatively, has anyone got suggestions to better manager this export process?

 

Thanks in advanced.

2 REPLIES 2
Highlighted
Solution Sage
Solution Sage

Re: Power BI Desktop - set fields for csv export using see records

Hi @xabit,

 

You should know that the data from "See Records" is coming from your original graph. If you save the changes like add/remove columns in "See Records", it also means that you are going to modify your original graph. Right?  

 

And you can refer to this article: https://docs.microsoft.com/en-us/power-bi/desktop-see-data-see-records. There's a Note: You cannot save changes from data that is viewed (or modified by users) in the See Records view to a report.

 

As I know currently there's no alternative way. So I would suggest you to submit an idea for feature request here.

 

Thanks,
Xi Jin.

Highlighted
Frequent Visitor

Re: Power BI Desktop - set fields for csv export using see records

Thanks @v-xjiin-msft for your input. I ended up just adding a table visualisation and added the fields to it, from here I can then extract the data. Not sure why I didn't think of that before!

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors