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.
I already tried using Copilot to troubleshoot this and had no luck, so feeding the problem into an LLM as you clearly have is probably not going to do any good.
But in case anyone else is wondering, I am the owner of both this model and the ones that refresh successfully. Data sources in the current file now shows exactly one entry.
Resolver IIHi rhodes25,
Fair enough, and that kills the ownership angle properly, so scratch that one.
The bit I still can't square is the refresh history. You said it's got one entry from last week. If a data-only refresh had actually run and just not picked anything up, there'd still be a row for it, pass or fail. There isn't one. So that refresh looks like it isn't starting at all rather than running and doing nothing useful.
Quick way to tell them apart: hit Refresh now and watch the history for a minute. If no new row appears at all, it isn't the credentials, it's that nothing is being dispatched, and that's a different problem.
Did a row show up?