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.
This seems to be controlled by server side. You may try to clear permissions in data source settings.
Hello, I'm facing the same problem. Did you manage to solve it out?
My PBI team and I are also facing the same issue - error message below.
Instead of restarting PBI Desktop, we found this quicker way to reconnect:-
Thanks @leoPBI for the solution!!
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.
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...
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?
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 Promptipconfig /flushdns