Forum Discussion
Advocate IIIssue 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.
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.
1 Reply
Shubham_rai955Super User
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.