PowerBI data is imported to Excel, why do I need to log in to Microsoft account every time I refresh

[鱼塘泛舟_Tony]

Hello everyone, I encountered the following problems when using Power BI: "Power BI model data import has been connected to Excel365 (Excel I have logged in to office 365 account), why do I need to log in to Microsoft account again every time I open refresh?" I really hope to get your help, thank you very much! Here's a screenshot of the question:

[v-yiruan-msft]

Hi @鱼塘泛舟_Tony ,

When you import data from Power BI into Excel, Excel needs to authenticate with Power BI to access the data. This authentication process requires you to sign in to your Microsoft account. Please try the following steps and check if they can resolve your problem:

• Update the version of Excel to the latest one
• Remove these credentials from the Credential Manager in your Control Panel: Why do I have to login to my Microsoft account every time I open an Office application (e.g. Word, E...

Best Regards

[鱼塘泛舟_Tony]

Hi, @v-yiruan-msft ,

I tried to follow the solution you gave, but it does not seem to solve the problem. My Excel is the latest version, and I have logged in the Microsoft account in advance, but I still need to log in again every time I open it to refresh data. In the first few months, the login window will not pop up, it can be directly refreshed.

Looking forward to hearing from you soon!

Best Regards，

Tony

[ATFabi]

Hello @鱼塘泛舟_Tony 

We have had this problem since the update in December / end of November. If we roll back to an old version of Office / Excel, for example from August 2023, then the window for authentication no longer appears. However, a refresh is still carried out without any problems. Just as it should normally behave. 😁

We have some Excel files in our company that are updated overnight. Since the latest versions of Office, this is no longer possible. We have also been in direct contact with Microsoft Support for several weeks, and they have already sent us a number of suggested solutions, but all without success.

What Microsoft is doing here is really extremely annoying and it looks like it affects all users who access their Power BI.

[鱼塘泛舟_Tony]

Hello,@ATFabi

Yeah, I can't agree with you more, I wonder if you have any solutions available? I want to implement automatic refreshes in the background, but I need authentication every time. I have been unable to find a solution, which makes me feel bad.

If I can't find a solution, I may have to use "automation" to implement it。