Forum Discussion

EmmanuelleD's avatar
EmmanuelleD
Frequent Visitor
5 years ago
Solved

Issues with scheduled refresh / gateway

Hi all,    My company is making the move from excel to power bi. I have experience creating reports in power bi but the background side of things is new to me and our IT consultants seem to have li...
Need Help
  • EmmanuelleD's avatar
    EmmanuelleD
    5 years ago

    The reason for error in sharepoint was simlpy that the user didn't have access to the sharepoint site. 

    I tried the full path for excel but it didn't solve the problem. We'll be refreshing the report manually if we can't find a way around this. 

collinq's avatar
collinq
Super User
5 years ago

Hi EmmanuelleD ,

 

I am thinking that the issue is that you are using a "shared network folder" from your PC and not a link to the actual file.  If the share on your PC is "S" drive, the gateway has no understanding of that.  You need to use the format of \\server\folder\file rather than your local path.

EmmanuelleD's avatar
EmmanuelleD
Frequent Visitor
5 years ago

Hi! 

How can I change that? When I select edit credentials the file path is greyed out and can't be changed. 

  • collinq's avatar
    collinq
    Super User
    5 years ago

    Hi EmmanuelleD ,

     

    The person that setup the Gateway wil lbe able to modify it and/or give you the permissions to modify it.

    • EmmanuelleD's avatar
      EmmanuelleD
      Frequent Visitor
      5 years ago

      Thanks, I'll check with them. 

       

      Have you got any idea why I get the error "We could not register this data source for any gateway instances within this cluster." when trying to connect to sharepoint? 

      • collinq's avatar
        collinq
        Super User
        5 years ago

        HI EmmanuelleD ,

         

        When you get the other issue with Microsoft, then you can check on this as well.  This could be directly related to the initial issue....or, of course, totally not related  🙂