Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cant refresh gateway connection with SQL and SharePoint list

Hi,

Previously, I have 2 data sources in my dashboard: SharePoint list and SQL server on-premise data gateway. I tried to schedule and refresh now on my dataset but I have an error below:

 

 

I already check on my dataset settings

 

Any suggestions on what we can do to get past this issue?

 

 

 

 

Need Help
  • ibarrau's avatar
    ibarrau
    4 years ago

    Hi. This is weird. I can think about two things. 

    First, I have never seen a sharepoint connection with gateway. You can try removing that source connection (or at least remove the skip connection because skiping can produce issues) from gateway and just configure its credentials in data source settings. In order to refresh a dataset with cloud and onpremise data you need to check the following option in the "manage gateway" menu. 

    That should allow to configure a schedule refresh with Sharepoint credentials and not gateway.

     

    Second, if all continue falling you can have the report broken in Service. Try changing the pbix file name and publish again. If there was a cache in Power Bi Service with the report broken that should fix it. The only issue about this is that if you had already shared the report with people you might need to do it again. If you have added people to workspace then you are fine.

     

    I hope that helps,

4 Replies

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    4 years ago

    Hi. This is weird. I can think about two things. 

    First, I have never seen a sharepoint connection with gateway. You can try removing that source connection (or at least remove the skip connection because skiping can produce issues) from gateway and just configure its credentials in data source settings. In order to refresh a dataset with cloud and onpremise data you need to check the following option in the "manage gateway" menu. 

    That should allow to configure a schedule refresh with Sharepoint credentials and not gateway.

     

    Second, if all continue falling you can have the report broken in Service. Try changing the pbix file name and publish again. If there was a cache in Power Bi Service with the report broken that should fix it. The only issue about this is that if you had already shared the report with people you might need to do it again. If you have added people to workspace then you are fine.

     

    I hope that helps,

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi ibarrau ,

      You're right, after I removed the gateway connection on the Sharepoint and configured the credentials in the data source, manual and automatic refreshes can be run.

       

       

       

       

      Thank you very much 

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous 

    I find a related post, not sure if this will help, for your reference 

    https://community.powerbi.com/t5/Issues/May-2021-Gateway-Error-SharePoint-Request-failed-The-underlying/idi-p/1857711/page/2#comments

     

    if this still doesn't solve your question, please let me know.

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

  • mmirtalaie's avatar
    mmirtalaie
    New Member
    2 years ago

    An important step which is missed in this response is to clear the browser cache before applying the changes