Analyze in Excel - Help

[Dgreen23]

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?

[lbendlin]

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?