Forum Discussion

Ar_Sh's avatar
Ar_Sh
Icon for Advocate II rankAdvocate II
1 day ago
Solved

Issue with native sql query

I am using a native sql query it is working in power bi desktop but failing in power bi service . internal error. any idea how I can resolve this.
General Comment
  • Shubham_rai955's avatar
    Shubham_rai955
    1 day ago

    This could be related to data source credentials, gateway configuration, or differences between Power BI Desktop and Service. Check whether the credentials and gateway settings are configured correctly in the Service. Also, try running the native SQL query directly against the database to rule out any query-related issues. If it still fails, check the refresh error details for more information.

Shubham_rai955's avatar
Shubham_rai955
Icon for Super User rankSuper User
1 day ago

This could be related to data source credentials, gateway configuration, or differences between Power BI Desktop and Service. Check whether the credentials and gateway settings are configured correctly in the Service. Also, try running the native SQL query directly against the database to rule out any query-related issues. If it still fails, check the refresh error details for more information.