Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
youngstees
Frequent Visitor

Credentials are missing or not valid

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.

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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

 

Capture.PNG

 

 

 

 

 

 

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.

1 ACCEPTED SOLUTION
v-qiuyu-msft
Community Support
Community Support


 

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

 

Capture.PNG

 

 

 

 

 


 

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-qiuyu-msft
Community Support
Community Support


 

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

 

Capture.PNG

 

 

 

 

 


 

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello @v-qiuyu-msft

 

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


Thanks!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors