Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Dgreen23
Helper III
Helper III

Analyze in Excel - Help

I have a report I want to analyze in excel. When I do this the file it spits out has no data formatting. This makes it impossible to sort pivot tables the way I need to. Does anyone have a workaround for this or know why all my data formatting is lost on the ODC file?

1 REPLY 1
lbendlin
Super User
Super User

What do you mean when you say data formatting?  After you added fields from the Power BI dataset to your Pivot table you can apply the usual formatting there.  Where are you stuck?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors