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
hugh-mandg
New Member

On Premise Gateway - Unable to link to SQL Server Data Source defined in Gateway

I have created a SQL/Server data source in an on premise gateway, where connectivity is working. When I publish a report using the same SQL Server connection I am unable to link it to the data source defined in the Gateway. I have granted myself access to the data source.

 

Data Source Settings in BI report: - mg1vdbaz35;FinanceProdSup

 

In Gateway:  Server = mg1vdbaz35,1433

                   Database =FinanceProdSup

                   Auth Method = Basic

 

I have even tried with data source setting in the report to be mg1vdbaz35:1433;FinanceProdSup, but still no joy. 

 

Anyone had this issue before and what is the resolution?

3 REPLIES 3
v-xiaoyan-msft
Community Support
Community Support

Hi@hugh-mandg

 

Can you provide a detailed error message or a screenshot of the error report page?

Please verify that you have the correct username and password. Also, verify that those credentials can successfully connect to the data source. Make sure the account that's being used matches the authentication method.

Or you may verify the name of the database and that the user credential has the proper permission to access that database.

 

Here are some common gateway error messages, Gateway Troubleshooting ,please check whether your problem is helpful, if not, please provide more detailed information to facilitate us to better solve your problem.

 

Hope it helps.

 

Best Regards,
Caitlyn Yan

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

aj1973
Community Champion
Community Champion

Hi @hugh-mandg 

How did you add your source to the Gateway? can you screenshot please!

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Gateway DS.pngPBI Data Source Settings.png

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors