Repeatedly prompted for account authentication when updating Power BI data from EXCEL.

[Yama236]

The repeated requests for account authentication are compromising convenience.

We seek improvement.

Steps to reproduce the issue:

1. Launch Excel

2. Data → Connect to Power BI service's semantic model → insert table

Check that the connection string is as follows:

Provider=MSOLAP.8;Integrated Security=ClaimsToken;Persist Security Info=True;Initial ～～～

3. Refresh data → Sign in

4. Save and close Excel

5. Launch Excel → Refresh data → prompted to sign in again.

There are others suffering from the same issue on the community site below, and currently, the only solution is to downgrade the version.

Related information

https://community.fabric.microsoft.com/t5/Service/Prompting-for-account-when-trying-to-open-Excel-with-Power-BI/m-p/4179571/highlight/trueM247942