Forum Discussion

Nickodemus's avatar
Nickodemus
Icon for Helper III rankHelper III
8 years ago
Solved

On-Premise Gateway Connection to SQL Server fine, but says I don't have one...

Hi All,   I am trying to setup a dataset scheduled refresh, but Power BI Service is refusing to accept that I have a data connection... I have setup the Gateway datasource and it states 'Connectio...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Nickodemus,

    Based on your screenshots, you are using different server names in gateway and Power BI Desktop.

    In Power BI Desktop, you use "." to connect to local SQL Server instance, please change it to the same server name as that you use in gateway connection string, then re-publish PBIX file, this way, you will be able to set schedule refresh for your dataset.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Nickodemus,

Based on your screenshots, you are using different server names in gateway and Power BI Desktop.

In Power BI Desktop, you use "." to connect to local SQL Server instance, please change it to the same server name as that you use in gateway connection string, then re-publish PBIX file, this way, you will be able to set schedule refresh for your dataset.

Regards,
Lydia

Nickodemus's avatar
Nickodemus
Icon for Helper III rankHelper III
8 years ago

Ahh!! Genius! Thank you. That worked a treat, and now it looks so obvious; I was using local server address, rather than the full address.