Power BI Service SQL Connection Error

[chawkinsitron]

I started getting a connection error in Power BI Service and Desktop. I corrected the Desktop file by Unchecking the "Encrypt Connections" Option and I am now able to connect via the desktop. I am still unable to update the data set via Service.

I get the following Details:

Cannot connect to the mashup data source. See error details for more information.
Please try again later or contact support. If you contact support, please provide these details.

Underlying error code-2147467259 Table: Dated_Functional_Yield.

Underlying error messageMicrosoft 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.)

DM_ErrorDetailNameCode_UnderlyingHResult   -2147467259

Microsoft.Data.Mashup.ValueError.Class   20

Microsoft.Data.Mashup.ValueError.DataSourceKind   SQL

Microsoft.Data.Mashup.ValueError.DataSourcePath   SERVER NAME;DB NAME

Microsoft.Data.Mashup.ValueError.Message   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.)

Microsoft.Data.Mashup.ValueError.Number   -2146893016

Microsoft.Data.Mashup.ValueError.Reason   DataSource.Error

Cluster URI   WABI-WEST-US-redirect.analysis.windows.net

Activity ID   ffc427ff-fa5f-41d8-b6b2-8af955ce5b5f

Request ID   30d65951-1398-0c8d-22c6-0d0f0eeebdd1

Time   2018-08-16 15:40:44Z

I have tried deleting the report and dataset from Service and reuploading the file with "encrypt Connection" unchecked. The Gateway software on the server is up-to-date. I cleared all of the permissions and re-entered them. I am still unable to connect. Looking for solutions.

Thank you,

Chris

[v-piga-msft]

Hi @chawkinsitron,

For your error messagem, here is a similar thread which has been solved.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[chawkinsitron]

Hi @v-piga-msft,

I have tried switching to my Personal Gateway. This gave me the same error. I uninstalled the Personal Gateway and reinstalled. I also checked to make sure the version of the Gateway and Power BI desktop are most up to date. I am still able to refresh in Power BI Desktop, but not in Power BI Service. I get a new error in Service. See below.

Last refresh failed: Mon Aug 20 2018 09:50:30 GMT-0400 (Eastern Daylight Time) 
An invalid credential due to signature doesn't match. Please check your connection data source credential.Hide details

Cluster URI:	WABI-WEST-US-redirect.analysis.windows.net
Activity ID:	a0a01528-38b8-edbb-0e5c-de127ec4d666
Request ID:	defe76b8-7903-8931-17f4-b5ac5c910783
Time:	2018-08-20 13:50:30Z

Thank you,

Chris 

[v-piga-msft]

Hi @chawkinsitron,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best  Regards,

Cherry

[chawkinsitron]

Hi @v-piga-msft,

The issue is not solved. I have submitted a ticket with my IT group who is now working with Microsoft to correct the issue. Interesting to note that Live Query appears to work, but Import does not. Even when using the same credentials on the same gateway. I will be pursuing this with my IT Department further.

Thank you,

Chris

[v-piga-msft]

Hi @chawkinsitron,

Based on your error message, it seems that the issue is caused by the credential you connect to the data source is invalid.

What kind of credential do you use when you connect the data source in Power BI Desktop? 

You should use the same credential when you add data source in Gateway. Maybe you could remove the data source you add before and add it again with the valid credential in Data Gateway. 

Best Regards,

Cherry