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.

     

Cookistador's avatar
Cookistador
Super User
1 year ago

If you open the report, did you see some information?

 

If I remember well, a day my gateway was down, the DQ refresh was working (when I clicked on the refresh button) but if I opened my report, I got an error message

  • Ynr225's avatar
    Ynr225
    Helper II
    1 year ago

    I am able to open the report and don't see any error message. When i open the report i can see the updated data in the report