Forum Discussion
Semantic model throwing a false "missing credentials" error on refresh
I seem to have managed to solve the issue by changing the data source name on the PBIX file to match the capitalization of the gateway. It then threw an error related to native database query permissions instead of the missing credentials, and seems to be running smoothly since I told it that it has permissions to run the native database queries.
On there I'm getting two copies of the same server/database configuration listed, one with the database name in camel case and the other in all lower case.
I have now made sure that there is only one datasource with the same capitalization that the gateway connection is using and the issue has not resolved itself.
v-saisrao-msftCommunity Support
Hi rhodes25,
Thank you GilbertQ, PauReis, for your insights,Thanks for the update on removing the duplicate source and matching the server/database casing. Since Microsoft requires the server and database names to match exactly, including case, that part is now taken care of.
Please then check that your account is listed under Users for the SQL Server gateway data source and that the gateway is running a supported current version.
After that, refresh the PBIX in Power BI Desktop on the gateway machine; if it works, try Refresh now in the Service and see whether a new entry appears in Refresh history; if it fails locally, collect the gateway diagnostics/logs.Manage a SQL Server data source - Power BI | Microsoft Learn
Troubleshoot the on-premises data gateway | Microsoft Learn
Troubleshoot refresh scenarios - Power BI | Microsoft Learn
Thank you. - v-saisrao-msft
HI rhodes25,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.
Thank you.