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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Tom,

         

        Thanks. Will check pinging the machine and gateway logs.

         

        The connection works in the service when using direct query, just not when the data is imported. Any idea why this would be?

         

        Regards

         

        Mike