Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

iBusinessBI

Analyze in Excel askes to sign in multiple times over and over again (from Excel Desktop App)

Submitted by Kudo Collector on ‎10-14-2024 09:16 AM

I have been working with Analyze in Excel for many years.

Previously after opening Excel it asked once to sign in, that's it.

About two weeks ago it started to ask to sign in every 10 seconds.

i do have one connection and multiple pivots. I think it started to ask for sign in for each pivot. please help

I think it is a bug, please help.

Status: Investigating
See more ideas labeled with:
4 Comments (4 New)
Comments
Anonymous
Not applicable
‎10-14-2024 11:17 PM

Hi  @iBusinessBI ,

 

Does clearing the local cache in Excel work for you? Have other users in your organization had similar experiences?

I tried to do a simple test but it doesn't seem to reproduce the problem, any more information would be great.

 

 

Best regards.
Community Support Team_ Caitlyn

iBusinessBI
Kudo Collector
Kudo Collector
‎10-15-2024 01:38 AM

I have cleaned the cache now. The issue remains.

Works great in the Excel web but in the Desktop app it askes to sign in twice FOR EVERY PIVOT (although all are from the same connection).

For example if I duplicate a sheet with a pivot, it'll immediately ask me to sign in again. twice!

It never behaved like that, only last week / last couple of weeks.

Maybe the recent NFA changes (I don't see any request for MFA)

Maybe something with the license (I have PPU in Power BI and Microsoft 365 apps for Business in office)

Maybe the office license is not enough (but it always was)

I have another customer (different domain, different company) that also started to behave like this.

 

iBusinessBI
Kudo Collector
Kudo Collector
‎10-15-2024 06:53 AM

I have just spent 5 hours trying to solve this! Including a phone call with Customer Support.
2 things worked for me:
1. Downgrading office to Version 2407 (Build 17830.20166) 
(this post: Excel - Unable to sign into data connection - Microsoft Community)
2. Removing "Catalog Rebound=True" from the connection string as proposed here https://community.fabric.microsoft.com/t5/Power-Query/Initialization-of-data-source-failed-Excel-Pow... 

 

So for now it works for me, but definetely something is wrong with office / analyze in excel - I don't want to downgrade office on the permanent basis

iBusinessBI
Kudo Collector
Kudo Collector
‎10-21-2024 12:19 AM

@Anonymous 

Hello. Did you escalate the issue with the Office R&D team?

More and more of my clients are having this issue.

We need the bug fixed please

Idea Statuses