Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cannot connect to the mashup data source

Hi all,   Really stuck!   I'm having problems refreshing a SQL server datasource from Power BI service. I can refresh the data in desktop, and can configure the datasource in the enterprise gatew...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Daniel

     

    The database is already assigned in desktop.

     

    Regards

     

    Mike

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Still getting this error message. Can anyone help? Thanks

      • TomMartens's avatar
        TomMartens
        Icon for Super User rankSuper User
        7 years ago

        Hey,

         

        without further knowledge, it will become quite difficult to provide some additional hints.

         

        But as you have already stated, other on-premises SQL Server data sources can be refreshed from within the Power BI Service using the same on-premises data gateway machine.

         

        So the question is what sets this database / SQL Server apart from the other data sources:

        • can you ping the database machine form the gateway machine
        • maybe the authentication mode for this data source is Kerberos whereas the gateway machine / the service account is not prepared for this

        Have you had a first glimpse at the log files of the gateway.

         

        Debugging this can become quite lengthy.

         

        Regards,

        Tom