Forum Discussion
Advocate VPERSONAL GATEWAY update: Your data source can't be refreshed because the credentials are invalid.
Are you only using services or are you using the desktop version as well? If your files are created in the desktop version and if that version does not match the version of the Gateway, they will not communicate. Update the desktop version and this should resolve . . . but only if you created the files in the desktop version.
If that doesn't work, clear your browser history, cache, and cookies to start fresh. If all else fails, run a Fiddler Trace and send in a ticket.
hi dbadmin - I had the same issue a while ago. Fixed by uninstalling Power BI and making sure to download the latest version. then reuploading the pbix files. Fixed it.
Hi,
I'm using power bi desktop to create my reports, I'm getting data form a SQL server DB and using the import option and all works fine in power bi desktop but when I publish it and tried to schedule the refresh or use refresh now option, I got this error: "Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again". (I setup the personal gateway too wo issues)
So I have 2 question:
1) My Power BI credentials need to be registered in my SQL DB? bcs I getting the data with a diff account (no power bi user)
2) If I can use diff accounts then why I'm getting this error? any idea
Responsive ResidentHi fcosalazar
1. No, you dont have to register your BI credentials in SQL - just need to make sure those credentials have access to the SQL DB.
2. The account you upload the data to PowerBI online (using the PowerBI Desktop Program) needs to be the same account you have setup in the Personal Gateway.
When you have this setup right sometimes you have to go into the refresh
Datasets -> Schedule Refresh -> Data Source Credentials
ED