Forum Discussion
Solved
Connecting to on-premises SQL Server
I hope someone can help me... I develop for a customer from home. I use Power BI Desktop on my laptop to connect to a backup of their SQL database hosted on my laptop (mycomputername\sqlserverinstanc...
Hi rbrtbvsschllnr ,
I'm afraid that If your power bi desktop and the SQL server are not in the same domain, you could use SQL authentication to have aceess to the database.
In addition, if you want to refresh the dataset in Power BI Service, I think the Server name, database name and the Authentication method should be the same in the power bi desktop.
Best Regards,
Cherry
Hi rbrtbvsschllnr ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry