Forum Discussion
Solved
Semantic model throwing a false "missing credentials" error on refresh
I have two reports built off the same base semantic model (one of them I took the original model, removed some tables, and was intending to add a few later), and both are having refresh issues in the...
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.
GilbertQ
Super User
Super UserHi rhodes25
Just a note that Power Query is case sensitive and that is why you would have been getting the error when you had the same data source but spelled differently. Just make sure that the data source that you are using matches what is in the gateway and it will refresh successfully.