Forum Discussion

Ynr225's avatar
Ynr225
Helper II
1 year ago
Solved

SQL server direct query dataset refresh

Hi All,   Due to some reasons I have disabled the On-premises data gateway in Power BI service. As I know if I disable it the dataset refresh will fail. But one of my dataset model which is created...
Need Help
Show and Tell
  • v-sdhruv's avatar
    v-sdhruv
    1 year ago

    Hi Ynr225 ,
    You try this approach to troubleshoot the root cause-

    • Open Power BI Service → Dataset Settings → see the Data Source Credentials section.

    • If it says "OAuth2" or "Anonymous" without a gateway, it's using a direct internet route.

    • If it says "Windows Authentication" and Gateway is missing, it should fail — if not, something else (like public SQL Server) is helping.
      or

    Maybe during dataset creation, you connected to a cloud SQL source without realizing it (example: Azure SQL Database, or hosted virtual machines exposed to internet).
    Hope this helps!
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-sdhruv's avatar
v-sdhruv
Community Support
1 year ago

Hi Ynr225 ,
You try this approach to troubleshoot the root cause-

  • Open Power BI Service → Dataset Settings → see the Data Source Credentials section.

  • If it says "OAuth2" or "Anonymous" without a gateway, it's using a direct internet route.

  • If it says "Windows Authentication" and Gateway is missing, it should fail — if not, something else (like public SQL Server) is helping.
    or

Maybe during dataset creation, you connected to a cloud SQL source without realizing it (example: Azure SQL Database, or hosted virtual machines exposed to internet).
Hope this helps!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.