Forum Discussion

jdunmall's avatar
jdunmall
Icon for Advocate I rankAdvocate I
10 years ago
Solved

Analyze in Excel: Initialization of the data source failed

Hi all,   Trying to get Analyze in Excel working. I tried it with a PBIX uploaded from desktop. I've installed the OLEDB package. I get the following error: Initialization of the data source failed...
Need Help
  • kcantor's avatar
    kcantor
    10 years ago

    I had this exact error. I uninstalled the add on and then re installed making sure to choose 64bit. After that, it allowed me to log in and export for analysis. While I had installed the correct version, a coworker installed the incorrect version. A clean install solved the issue for both of us.

jllelis's avatar
jllelis
Icon for Advocate I rankAdvocate I
8 years ago

Hi All,

 

The lastest office update release has a correction for this issue, try to update it and see if works. If not, there is a workaround in this link: https://pbiwiki.com/wiki/TSG_-_Analyze_in_Excel look for the topic: MSOLAP 8 uses a bad adal version. Hope it helps!

 

Best,

João Lucas

jeremyhager's avatar
jeremyhager
Regular Visitor
8 years ago

Hi jllelis,

 

It seems you've linked an interal wiki for Microsoft-tenant-only users. Can you post the workaround in this forum or on a public wiki?