Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I'm receiving the following error when trying to hook up an On-premises data gateway to SQL Server (text of error contained within spoiler).
I'm able to connect to the SQL Server via ODBC. I've tried using both "Basic" and "Windows" authentification method. I've also tried to manually access the database with no issue and I've had no issues setting up a personal gateway, it just seems a regular on premises returns the Error Code: DMTS_PublishDatasourceToClusterErrorCode. Does anyone have anything that can help with this?
Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details Activity ID: e76ad1b0-384d-403b-b87a-186a23e4cde6 Request ID: d19779c9-9ce3-6880-4e31-41c40841a31e Cluster URI: https://wabi-uk-south-redirect.analysis.windows.net/ Status code: 400 Error Code: DMTS_PublishDatasourceToClusterErrorCode Time: Tue Jun 23 2020 17:05:04 GMT+0100 (British Summer Time) Service version: 13.0.13599.209 Client version: 2006.2.01600-train MSG-PowerBI-GW-01: There was an error in the data gateway. Underlying error message: The parameter is incorrect. DM_ErrorDetailNameCode_UnderlyingHResult: -2146893785
The underlying issue came down to an IT/Firewall blocker that needed to be fixed by our infrastructure team, as this wasn't a PBI or credential issue - they likely need to allow the gateway to connect.
The underlying issue came down to an IT/Firewall blocker that needed to be fixed by our infrastructure team, as this wasn't a PBI or credential issue - they likely need to allow the gateway to connect.
Which gateway version you are using? I can connect to sql server successfully in my environment using gateway June 2020. Maybe you can update the gateway to the latest version to try to configure again.
Best Regards, Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Announcements
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
