Analyze in Excel does NOT yield a .odc file

[MAK3918]

Hi, PowerBI Pro user here.

From July 6, 2020 through August 4, 2020 - I somehow lost the ability to yield an .odc file when selecting 'Analyze in Excel' on a PowerBI Report.

Now when selecting 'Analyze in Excel' it downloads a .xlsx file. When opened, the .xlsx shows the ability to create a pivot table but not of the underlying fields or metrics from the PowerBI Report are visible.

Help! Need to be able to re-download an .odc file. 

[lbendlin · Accepted solution]

Just go to the connection properties to see the information you need.  The .xlsx file has the .odc data included.

Provider=MSOLAP.8;Integrated Security=ClaimsToken;Persist Security Info=True;Initial Catalog=sobe_wowvirtualserver-67e4a5b8-5d92-xxxx-954a-960e81395ba3;Data Source=pbiazure://api.powerbi.com;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;Identity Provider=https://login.microsoftonline.com/common, https://analysis.windows.net/powerbi/api, 929d0ec0-xxxx-4b1e-bc7c-b754a28bddcc;Update Isolation Level=2

[CarDP]

Hi! Thanks for this.

Can you be a bit more specific in how to do this, please?

Thanks @lbendlin