cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nick93 Member
Member

Error refreshing dataset using on-premise gateway connection

Hi,

 

I'm new at using Power BI service and data gateway. I am in trouble with refreshing my datasets. I have an on-premises data gateway and I added some data source, from a Web site and from SQL Server. I built a Power BI Desktop file using data from the Web site, then I logged it in Power BI Service and set planned refresh. The refresh was not completed as I obtained this error message:

 

Help.png

 

I just don't understand what I am missing. I think my credentials are ok, I set them in data gateway and while setting data refresh for my dataset. I use basis credentials with "sa" as username, should I use maybe Windows credentials? What's the password for that? I have Microsoft account and many others, but I don't understand what's my Windows account and if it's necessary to solve my problem.

 

Thank you very much for help!

 

Please help me

5 REPLIES 5
Super User
Super User

Re: Error refreshing dataset using on-premise gateway connection

HI there

From your error, it appears to be with your Website connection in that it needs a valid credential in order to extract the data from the website.


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
nick93 Member
Member

Re: Error refreshing dataset using on-premise gateway connection

Thank you for help! So the problem may be the website and not my gateway or my credentials? Anyway, how can I recover my Windows credentials? 

Super User
Super User

Re: Error refreshing dataset using on-premise gateway connection

I do not think you Windows Credentials are an issue. Those appear to be right for connecting to your SQL Server.


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
nick93 Member
Member

Re: Error refreshing dataset using on-premise gateway connection

I tried with another website and gain the same error. Can't it be something about Windows credentials? I'd like to try them but I don't know how to recover them.

Super User
Super User

Re: Error refreshing dataset using on-premise gateway connection

Hi there

I would imagine for a Website it would not use Windows credentials.

If you are not sure what the credentials are, I would suggest creating new ones if no one in the organization can assist?


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"