Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am using an organizational account and a report generated by someone in the company. At some point in the past, that someone connected to and pulled data from our MS SQL database and was able to refresh data at will. They even shared the report with someone else in the organization who had no issues using the original creator's credentials to refresh the data on his own machine.
I, however, am unable to use ANY credentials to access that same information when I bring the report onto my machine. Both myself and the creator are obviously credentialed on the server side (I am able to connect to other non-PowerBI-related parts of the same server by other means). When I try to use any credentials, even unauthorized ones, I get the following error:
DataSource.Error: Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Here's what I've tried:
Just to reiterate, I know for sure that my credentials are correct and there are no erroneous keystrokes anywhere in the process. I was able to successfully log in and pull data while using my own credentials on a colleague's machine.
Some other potentially relevant information:
I am using a non Microsoft Store version of PowerBI. It is the same version number as my colleaugues', though (2.86.902.0 32-bit (October 2020)). I got my version from here because I was running into an error on the official Microsoft Store version of the app where I was unable to open ANY shared .pbix files. Switching to this non-store version resolved that issue, however my colleagues are still using that store version with no issues.
I am unsure where to proceed next. I have done my best to look for this issue on various forums and plan to commence with the steps outlined here, though I dont see it being helpful because again, we are able to get into the server by other means.
HI @Anonymous,
So you mean this issue only appears on a specific device and it works well when you test with other devices with the same account?
If this is the case, I suppose this should more be related to your device's settings. Any particular policies, rules, security, permissions setting enabled on your device? Is there any software/hardware environment difference between you and your colleagues? Please provide more detailed information to help us clarify your issue.
How to Get Your Question Answered Quickly
BTW, since this is a specific device-related issue. I'd like to suggest you open a support ticket to contact to power bi team with detailed device settings to help troubleshoot backend reasons.
submit a support ticket
Regards,
Xiaoxin Sheng
User | Count |
---|---|
141 | |
70 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |