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
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,