Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.