Forum Discussion

alurpal's avatar
alurpal
Copper Contributor
Aug 28, 2019

Excel blank screen / unresponsive when authenticating sharepoint online data source

I'm having this strange issue when I attempt to use power query to consume a sharepoint online resource.   When I get to the authentication window, I select Microsoft Account and a window opens up ...
Jeapster's avatar
Jeapster
Copper Contributor
Jun 17, 2020
I’ve found a workaround! I uninstalled office 365 x86 and installed office 365 x64. It now works perfectly! I think the issue was caused by the mashup shared components being a mix of 32bit for office and 64bit for power BI!
Lissessul's avatar
Lissessul
Copper Contributor
Jun 17, 2020

Jeapster I have installed Office ProPlus 365 64bits already, same issue.

  • Lissessul's avatar
    Lissessul
    Copper Contributor
    Jun 17, 2020
    In Power BI it works fine, but on Excel it doesn't, could it be related to Power BI version?

Resources