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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
NandanHegde
Super User
Super User

Error via On Premises Data Gateway to SQL server

I have installed an On Premises gateway on a server.

I am able to access the SQL Server from the server on which the gateway is installed and the PBIX/report development was done from the same server.

 

But getting the error in Powerbi Service when trying to refresh the dataset/semantic model :

 

NandanHegde_0-1708581722352.png

 

Error :

  • Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The received certificate has expired.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"20"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"<<>>"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The received certificate has expired.)"}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"-2146893016"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.State","detail":{"type":1,"value":"0"}}],"exceptionCulprit":1}}} Table: Query1.

 

 

So what should be the next steps?
Is there any settings within the gateway wherein we can exlcude encrypt credential similar to how we did in Powerbi desktop similar to below link :

https://community.fabric.microsoft.com/t5/Report-Server/PowerBI-connection-issue-The-received-certif...

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Has nothing to do with the gateway.  On the SQL server renew the expired certificates and then restart the SQL Server service.

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

Has nothing to do with the gateway.  On the SQL server renew the expired certificates and then restart the SQL Server service.

Hey @lbendlin 

Thank you for your response.

But my query was more on :

We were able to connect to the database via Powerbi desktop by disabling encrypt connection, so is there any similar setting across On Prem gateway set up/Powerbi service.


There is not.  We had a ticket open with Microsoft on that topic, and they swatted it away. They have no interest in allowing unencrypted connections on the gateway.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors