Forum Discussion

cmiranda's avatar
cmiranda
Frequent Visitor
2 years ago

Unknown error from external service: DMTS_PublishDatasourceToClusterErrorCode

We are running into some issues when connecting a Dataflow to an onpremise SQL Server.

We get the following error message when configuring the connection:

 

Unknown error from external service: DMTS_PublishDatasourceToClusterErrorCode

 

This only happens with PowerBI Dataflows. If we connect to the same SQL data source from inside PowerBI we don't encounter this error.

 

 

Dataflow
Need Help

2 Replies

  • cmiranda's avatar
    cmiranda
    Frequent Visitor
    2 years ago

     When you say "within Power BI" are you referring to Desktop on the same network as the SQL Server? - Correct

     

    Is the SQL Server a Microsoft SQL Server? - Yes, On premise, not cloud

     

    What connector are you using? - When I'm setting up the dataflow in PBI web I use the SQL Connector

     

    I also just got off the call with Microsoft and they said it might to try using admin credentials in the connection and check firewall. I'm going to try and see

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    cmiranda When you say "within Power BI" are you referring to Desktop on the same network as the SQL Server? Is the SQL Server a Microsoft SQL Server? What connector are you using?