Forum Discussion

sahilhira162's avatar
sahilhira162
Icon for Helper I rankHelper I
9 years ago

Your data source cannot be refreshed because the credentials are invalid

I have created a report and installed personal gateway on my system. I am extracting data from SQL Server, its working fine when I refresh in Power BI Desktop version but not in Power BI Online. I am...
Need Help
nsc's avatar
nsc
Icon for Advocate II rankAdvocate II
9 years ago

Hi Sahil

 

Are you using windows or database credentials to connect to your database? If windows you can always try to switch to database, if windows 

 

Regards Niels

  • sahilhira162's avatar
    sahilhira162
    Icon for Helper I rankHelper I
    9 years ago

    Hi nsc

     

    I used database credentials to connect to my database, but its giving me this error "Your data source cannot be refreshed because the credentials are invalid". I got the same credentials error on my power bi desktop as well when I used database connection. I am confused as I use the same user name password to connect my db. When I tried and switched to windows authentication, its not throwing any error and works fine on power bi dekstop but doesn't refresh online. 
    Any leads are appreciated.

    Regards,
    Sahil