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: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

skpeter

Authentication failing after approx 30 minutes of inactivity

Submitted by on ‎01-19-2021 09:05 AM

We are using PowerBI Desktop for connecting to Azure SQL analysis services data model with Direct query.

All users are facing an Authentication failed error after approx 30 minutes of inactivity in the Power BI desktop.

They have to restart the PowerBI desktop after they see this error.

Refresh does not resolve this problem.

We are using up to date version of the PowerBI desktop.

Status: New
See more ideas labeled with:
10 Comments (10 New)
Comments
v-chuncz-msft
Community Support
Community Support
‎01-20-2021 01:07 AM

@skpeter 

 

This seems to be controlled by server side. You may try to clear permissions in data source settings.

okusai3000
Helper IV
Helper IV
‎01-22-2021 12:16 PM

Hello, I'm facing the same problem. Did you manage to solve it out?

 

thanks!

Anonymous
Not applicable
‎01-28-2021 09:29 AM

My PBI team and I are also facing the same issue - error message below.

 

leoPBI_0-1611854664011.png

 

Instead of restarting PBI Desktop, we found this quicker way to reconnect:-

leoPBI_1-1611855000484.png

 

leoPBI_0-1611854986649.png

 

leoPBI_2-1611855076211.png

 

 

okusai3000
Helper IV
Helper IV
‎01-29-2021 10:58 AM

Thanks @Anonymous for the solution!!

Anonymous
Not applicable
‎02-01-2021 02:20 AM

@okusai3000 

That's very kind, but it's more of a workaround - my suggestion just makes reconnecting faster. This is error is still there I'm afraid.

jpl
Regular Visitor
‎02-03-2021 05:58 AM

Hi,

I have the same issue working on PBI Desktop.

I found also this workaround but it makes me craszy to have to redo it 8 times per day...

Any solution?

Tks,

 

seedjay1
Regular Visitor
‎02-26-2021 07:55 AM

Bumping this back to the top.

 

Yah the Data Source Setting re-connect process works, but it's totally annoying to have to do all the time.

 

Does anybody know what server setting eliminates this issue?

Anonymous
Not applicable
‎03-05-2021 02:36 AM

My teams' PBIX have stopped erroring with that "Authentication failed" message for a week or so ‌‌😁

I wonder if it's been fixed by the Feb PBI Desktop Update. The error stopping seems to have coincided with some visuals not loading / displaying in PBIX until refreshed (but the visuals display OK when published to PBI.com).


An database colleague told me that flushing the Windows' DNS cache *may* help if you're (still) getting authentication issues (but really this is meant for when failure/nothing happens when trying to authenticate via a login popup) :-

In Command Prompt
ipconfig /flushdns

image.png

 

Anonymous
Not applicable
‎08-25-2021 04:11 PM

Hi All,

We're still having this issue even with the latest PBI Desktop. Similar like OP, but we're using Live connection to Azure Analysis Services instead of Direct Query. And even worse, it can happen in less than 30 minutes.


Our workaround is exactly like @Anonymous mentioned with data source reconnect.
Requesting solution from Microsoft about this. We've been using this setup for around 3 years now, and this issue happened around this year only.

@Anonymous the flush DNS you mentioned, it is for the client computer who's running PBI Desktop?

Anonymous
Not applicable
‎08-27-2021 10:55 AM

@Anonymous yes, that's correct: flush DNS on the local computer running PBI Desktop ... although it may not help

Idea Statuses