Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Authentication failing after approx 30 minutes of inactivity

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
Comments
v-chuncz-msft
Community Support

@skpeter 

 

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

okusai3000
Helper IV

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

 

thanks!

leoPBI
Advocate II

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

Thanks @leoPBI for the solution!!

leoPBI
Advocate II

@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

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

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?

leoPBI
Advocate II

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

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 @leoPBI 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.

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

leoPBI
Advocate II

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