Forum Discussion
henryco88
Helper II
Helper IIError change connection server from loclahost to server sql
Hi, I have a report connected to a localhost server. Now I would like to change the connection to a sql server which contains the same data and metadata of localhost. I clicked to "Transform Data" ...
V-lianl-msft
Community Support
Community SupportHi henryco88 ,
Open your Desktop file and go to File → Options and settings → Data source settings.
Select the sql db and right-click and then edit permissions.
You can connect to SQL Server in Power BI Desktop using SQL authentication credentials. Choose Database option in the following screenshot, then enter your username and password to connect to SQL Server.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.