Forum Discussion
Data export table not export repetead measures
hi guys,
I have created a matrix table with some measures in powerbi that some people in the team needs to takes the values using the Export data.
The problem is that the people in the company in their template (that they can't modify..) have some columns that are repetead (imagine... sales product repetead 3 times with the same values). For that i have created a big matrix table with the same columns that they have and in these columns i put the same measure each time (in order to not create redundant measures). the problem is that when i export the excel, the repetead measures dont appears in the excel.
someone know if there is a possibility to export everthing in the table ?
2 Replies
Hi dobregon ,
You said that when export data, it will have repeated column. I test this in my environment, I find that it will export data in current visual , if measure repeate in visual, it also will repeate when export. So if you want no repeated column in Excel, I think you need to remove the repeated column or measure in visual. By the way, you also could save the pbix in service, then used who have permission could copy and re-use its dataset.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dax thanks for the response, but it is the oposite jeje
Example, i have a measure like "sales prod = Sum(bla bla bla)"
And in the table that we want to have in the service and the people export to excel the measure "sales prod" apprears with the same name x5 times, when i click export in the excel the measure appears only in the first time, the rest are removed
