Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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:

 

 

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

Need Help

5 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    8 years ago
    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.
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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? 

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        8 years ago
        I do not think you Windows Credentials are an issue. Those appear to be right for connecting to your SQL Server.