Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cannot remove a DataSource

Hi

 

I have a PowerBi Model, that is on desktop but also on PowerBi Service with auto-refresh through a gateway.

This was originally having a query from ServerA. But now is has to get the same query but from ServerB.

 

I've changed and triple-checked that the SourceB doesnt exists in any of the querys, but the auto-refresh fails and throws an error, saying that I can't connect to SourceB.

 

I've checked also in PowerBi Desktop, and in the DataSource the old source is still there. I've cleared the permissions, and it keeps me asking for permissions to access to a datasource that is not being used. The Change Source button is disabled, so I can't change it. The delete button is also disabled.

 

What else can I do? It's annoying that there is no easy way to delete a data source.. even when it is not being used!

I'm using PBI Desktop version 2.93.641.0 64-bit (may de 2021)

This is the 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 client and server cannot communicate, because they do not possess a common algorithm.)"}},{"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":"10.XXX.XXX.XX, 1433;Source_B"}},{"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 client and server cannot communicate, because they do not possess a common algorithm.)"}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"-2146893007"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: TABLE_NAME.

 

The table TABLE_NAME don't have the source B in any part of the code (Checked it on the Advanced Editor)

 

Thi are the screenshot of the DataSource setting in PowerBi Desktop:

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Finally I solved it.. There was a function that was using the old server. Changed it and then the Old source dissapeared from all tables.

    The error message is definitely wrong, because the reference to the old server was not in the table showed in the error message.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Finally I solved it.. There was a function that was using the old server. Changed it and then the Old source dissapeared from all tables.

    The error message is definitely wrong, because the reference to the old server was not in the table showed in the error message.

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Based on what I got. After publishing the file with the changed connection. have you checked the data source setting in power bi service and updated those if they are showing any error. Also, have you corrected gateway details under three dots -> setting -> manager gateway

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I've check in PBI Service in the gateway tab, and the old server (Source B) is still there, and I can't disable it for the model. In the data source setting I didn't find any option that could be useful.. Any other idea? Thanks!