EXEL keeps looping for acc login every time you refresh PowerBI data.
- OPEN CMD (admin rights) and uninstall MS security updates
cd %programfiles%\Common Files\Microsoft Shared\ClickToRun
and
officec2rclient.exe /update user updatetoversion=16.0.17830.20166
2. If problem still persist with EXEL file, open it go to DATA – QUERIES & CONNECTIONS, right click on CONNECTION – PROPERTIES – DEFINITION
Change MSOLAP.8 to MSOLAP.7 and delete Catalog Rebound=True if persist.
Example bad:
Provider=MSOLAP.8;Integrated Security=ClaimsToken;Persist Security Info=True;Initial Catalog=sobe_wowvirtualserver-434fe5cc-525c-4b24-a6a3-f9d9e799c35b;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-7a41-4b1e-bc7c-b754a28bddcc;Catalog Rebound=True;Update Isolation Level=2
Example good:
Provider=MSOLAP.7;Integrated Security=ClaimsToken;Persist Security Info=True;Initial Catalog=sobe_wowvirtualserver-434fe5cc-525c-4b24-a6a3-f9d9e799c35b;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-7a41-4b1e-bc7c-b754a28bddcc;Update Isolation Level=2