Forum Discussion

MAK3918's avatar
MAK3918
New Member
6 years ago
Solved

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 selectin...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi! Thanks for this.

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

Thanks lbendlin