Forum Discussion
Invalid Connection Credentials - One user but not another
as its Azure SQL server connection then I am pretty sure its because of SSO enablement for direct query, Please reachout to the connection owner and request then to disable that, it will fix the issue
Hi teetoes ,
This error may occur when the user’s credentials are not validated or updated by the Power BI service. There are a few possible causes and solutions for this issue:
- The user may have saved incorrect credentials for the data source in Power BI online. To remove or update the credentials, go to Settings > Data source settings > Edit permissions > Clear permissions.
- The user may have a different role or access level than you in the workspace or the data source. To check and change the user’s role or access level, go to Settings > Manage access > Add and manage access.
- The user may have a firewall or proxy that blocks the connection to the data source. To resolve this, make sure the user’s network allows the required IPs and ports for Power BI.
- The user may have an outdated version of Power BI Desktop or the gateway. To fix this, make sure the user has the latest version of Power BI Desktop and the gateway.
Solved: Invalid connection credentials - Microsoft Fabric Community
Solved: How to correct invalid credentials in PowerBI onli... - Microsoft Fabric Community
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- The user may have saved incorrect credentials for the data source in Power BI online. To remove or update the credentials, go to Settings > Data source settings > Edit permissions > Clear permissions.
- The user's credentials have not change since she was able to successfully access the report on the 19th. And she does not own the model, I do not own the model. This issue is in the powerBI Service.
- The user may have a different role or access level than you in the workspace or the data source. To check and change the user’s role or access level, go to Settings > Manage access > Add and manage access.
- Yes, she is a contributor, I am an Admin. However, other Contributor levels on her team are able to access and view data in the report.
- The user may have a firewall or proxy that blocks the connection to the data source. To resolve this, make sure the user’s network allows the required IPs and ports for Power BI.
- We are on the same network which is behind a firewall. She has not changed her method of access so this does not make sense.
- The user may have an outdated version of Power BI Desktop or the gateway. To fix this, make sure the user has the latest version of Power BI Desktop and the gateway.
- Power BI desktop version should have no impact on if she can see a report in the Service. The report is published to the service and has been in place for about 5 months. She has not had issue accessing it until the 23rd of this month.
As I mentioned, this is in the Service and impacts another user. I don't feel providing a PBIX file is appropriate in this instance. And the desired outcome is for her to be able to open and view the report again.