sunnyleung
Advocate I
6 years agoStatus:
New
Data refresh through PBI Gateway keep prompting credential missing incorrectly
While using PBI Service with on-premise data gateway connecting local excel files, the refresh keeps failed with "credentialMissing" error, however all credentials has already been given and verified...
Anonymous
6 years agoNot applicable
sunnyleung mlucking HemantNagar I can confirm my issue is now resolved, Steps I have taken below has worked. Please note Microsoft Engineer has not come back to me yet, but I cant wait on them and kept trying different things. See below what has worked for me (I am not sure which step has solved but see the list of actions I have taken):
- Uninstall my Power BI desktop version (2.84.802.0 64-bit).
- Installed latest updated Power BI desktop version (2.84.861.0 64-bit).
- Get the old version of your Power BI desktop file when it was upload on the service and was working fine. Lucky for me our drives store back ups twice a day so I found the last modified version which was working fine. (This is the most important step, if you don't have the last working version file then it wont work).
- Make all the changes to this old version file again, add data or visual changes you wanted to make and upload the file on the service, you can replace the existing file on the service.
- And hit manual refresh button or if your file has scheduled refresh activated it will automatically start to refresh and it will not fail.
Let me know if you need me to explain anything in detail. Got to go to a meeting, try it out.
Regards,
Nick.