cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hmeng3 Frequent Visitor
Frequent Visitor

Unable to Open ODC file by Clicking Analyze in Excel

I recently published a dashboard to my colleagues. I am able to download the odc file and open it successfully in Excel. But one of my colleague is not able to open it once the ODC file is downloaded from Power BI web version. He already downloaded the "analyze in excel update". When he opens the odc file, an error message pops us saying "Unable to open or read this connection file. Either the file has been damaged or the file format is not valid".

 

I helped him change the outside data security settings from Excel, and enabled all the outside sources. I also made sure that he has the permission to view and edit the dashboard. But he is still not able to open the ODC file from his Excel. Does anyone know what is going on?

 

I appreciate for any suggestions or help if anyone has any sort of ideas.

6 REPLIES 6
Super User
Super User

Re: Unable to Open ODC file by Clicking Analyze in Excel

I assume all your colleagues have the Pro licenses, correct?
maybe this article will be helpful:
https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel

 

otherwise could it be that your colleague's Excel instalation is corrupted?

hmeng3 Frequent Visitor
Frequent Visitor

Re: Unable to Open ODC file by Clicking Analyze in Excel

Thank you for your quick response. I have looked into the link you provided to me, and I don't think it is any of those problems.

 

Should he try to reinstall the Microsoft Office? His Excel works normally if only performing regular Excel tasks, and the only problem with his Excel is that it does not open the ODC file.

Super User
Super User

Re: Unable to Open ODC file by Clicking Analyze in Excel

to start you can try sending him ODC file generated on your PC, or maybe some of the ones that other colleagues are using - if you're sure the ODC file he uses is not corrupted, then the logical conlcusion would be something is wrong with his Excel

hmeng3 Frequent Visitor
Frequent Visitor

Re: Unable to Open ODC file by Clicking Analyze in Excel

Actually he was able to open the odc file that was generated from my computer. I sent the odc file to him, and he was able to open it using his excel. So I don't think it's the problem of his excel right? In this case, what do you think might be the problem?

 

Thank you very much!

jmalone Regular Visitor
Regular Visitor

Re: Unable to Open ODC file by Clicking Analyze in Excel

You might try using the "Power BI Publisher" add-in for Excel. It allows you to connect to a Power BI dataset without having to download the ODC file from the PBI service. You end up with the same thing (a live connection to the PBI dataset)...this is just a different way to go about it.

Highlighted
hmeng3 Frequent Visitor
Frequent Visitor

Re: Unable to Open ODC file by Clicking Analyze in Excel

Thank you for your suggestion! Actually I tried that way by using power bi publisher for excel, and it worked for him. I was just trying to figure out why odc file can be successfully opened from my end, but it does not work on his end. Downloading the odc file is easier, but if we cannot solve the problem, we will just go for the alternative way.