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, I imported an excel file data in service which has numeric fields summarized and sigma added automatically. Is there an option to change the summarize settings in Power BI service similar to Desktop?
Solved! Go to Solution.
You can anytime download your file from the server make change and post it to the Service.Is there any problem in doing that ?
Option is with Power BI Desktop not service
Inside Power BI Desktop: Click on the column you would like to remove summation; Click on the Modeling tab; Toggle Default Summarization to Don't summarize.
Thanks,
Ritesh
I don't have a power bi Desktop file for the excel data. I am importing data from excel directly.
You can anytime download your file from the server make change and post it to the Service.Is there any problem in doing that ?
Hi, it should not be a problem. thanks.
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.