Forum Discussion

sahilhira162's avatar
sahilhira162
Helper 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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

sahilhira162,

Please use same authentication type and account in Power BI Service and Power BI Desktop. In your scenario, where do you install the personal gateway? Are you able to connect to SQL Server via SQL Server Authentication from SSMS that is installed in the same machine with gateway?

Regards,
Lydia

sahilhira162's avatar
sahilhira162
Helper I
9 years ago

Anonymous

 

I am using windows authentication type on both Power BI Desktop and Power BI Online, it work fine on Power BI Desktop but doesn't refresh on Power BI Online. When I use database authentication type on my Power BI Dekstop and Power BI Online it throws this "Your data source cannot be refreshed because the credentials are invalid" credentials error. I have installed personal gateway on my machine but I don't have SSMS installed on my machine, Is this a problem.? I have Manage Engine ServiceDesk Plus installed on my machine and I connect to it using the same db credentials.


Regards,
Sahil

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    sahilhira162,

    Do you get errors in refresh history when you use windows authentication type on both Power BI Desktop and Power BI Online? Have you set schedule refresh properly? SSMS is just a test path. 

    Besides, how about you use on-premises gateway to refresh the dataset?

    Regards,