Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi Team,
I'm using Matrix visual with conditional formating with rules and when i export the data into CSV format , i'm seeing the data "Measures" data too .Eg: I wrote measure like , Sales change = current - new ,so this i have given as conditional formating in matrix visual . but here when i export the data into CSV format , i'm getting the data which i wrote measures with separate column. but in excel format i don't see this extra column. only issue with CSV format. Any help is appriciated.
Solved! Go to Solution.
Hi @Bajigntr -Exporting data from Power BI to a CSV format, it includes all underlying data, including measures, which can lead to seeing additional columns too .
if you want to export data in .csv then you need to add required fields only in table chart as like new, sales excluding Sales Change measure.If creating a separate table is not feasible, you might have to manually modify the CSV file post-export to remove unwanted columns.
Exporting data in CSV is a simpler format and doesn't support the rich formatting and structure that an Excel file does. As a result, complete data used to generate the visual,calculations and measures, are included in the exporting in CSV format.
Hope i have answered to your query.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
Hi rajendraongole1 , but i don't see this matter any where in Power bi documentation . with excel i'm not getting any extra columns , issue is only with CSV format . so is there anywhere written in power bi documentaion , if yes, could you please share me link
Hi @Bajigntr -Exporting data from Power BI to a CSV format, it includes all underlying data, including measures, which can lead to seeing additional columns too .
if you want to export data in .csv then you need to add required fields only in table chart as like new, sales excluding Sales Change measure.If creating a separate table is not feasible, you might have to manually modify the CSV file post-export to remove unwanted columns.
Exporting data in CSV is a simpler format and doesn't support the rich formatting and structure that an Excel file does. As a result, complete data used to generate the visual,calculations and measures, are included in the exporting in CSV format.
Hope i have answered to your query.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
75 | |
60 | |
37 | |
33 |
User | Count |
---|---|
102 | |
56 | |
52 | |
46 | |
40 |