Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
In report backend has 24 columns (included 5 aggregate columns(A,B,C,D,E) "default category is SUM")
I am using B aggregate column in report.
In export underlying data contained 20 columns. Only B aggregate column was present. Remaining 4 columns were excluded from underlying data in that report.
Why?
we can't get all aggregate column in underlying data without used in visual?
By
Gnanasekar
Solved! Go to Solution.
Hello, Power Bi export functions just add the text columns and the used ones in the visualization. If you want to export something different to that you have to approches:
1- Create a table visualization in a page to export columns you have selected previously.
2- "Edit Report" on service, then click on "See Records" in visualization. You will see the default columns to export, add the the four you don't have and then export. This won't keep saved.
Regards,
Happy to help!
Hello, Power Bi export functions just add the text columns and the used ones in the visualization. If you want to export something different to that you have to approches:
1- Create a table visualization in a page to export columns you have selected previously.
2- "Edit Report" on service, then click on "See Records" in visualization. You will see the default columns to export, add the the four you don't have and then export. This won't keep saved.
Regards,
Happy to help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.