Forum Discussion
Analyze in Excel does NOT yield a .odc file
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.
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
2 Replies
- lbendlin
Super User
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
