Credentials are missing or not valid

[youngstees]

Hello!

I've just installed the On-Premise gateway on my laptop for testing purposes and have added a SQL Server instance to the gateway.

All good so far, but when connecting to the source I get the error below:

So I have a domain account (Given by my organization, not AAD) and an on.microsoft account (Power BI Pro user). Shouldn't I be able to connect to the source when I have used the domain account credentials in the data source settings? Or do I have to link these accounts in some way? Or do I need to link the Power BI subscription to my domain account?

Any help appreciated.

[v-qiuyu-msft · Accepted solution]

---

All good so far, but when connecting to the source I get the error below:

---

Hi @youngstees,

Where did you connect to the source then the error threw out? In Power BI Desktop or Power BI Service?

If you set the dataset to use this data gateway to connect to the SQL Server database, the error shouldn't throw out, as data source connection is successful. If you connect to the SQL database in Power BI Desktop, it doesn't require data gateway. You need to verify if you use the Windows Authentication or SQL Authentication, with corresponding credential entered.

By the way, I don't suggest you use "." as server name in data gateway, please change it to actual server name. But make sure Server and database name match between Power BI Desktop and the data source within the on-premises data gateway gateway.

Best Regards,
Qiuyun Yu

[youngstees]

Hello @v-qiuyu-msft

Thank you for your answer! Got it working, changing from "." to the actual server name did the trick.

Thanks!