Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Sharepoint Folder - Accessing an external sharepoint (not owned by my company)

 

 

Hi, let's see if someone can help me handle this issue. 

  

I am trying to access a sharepoint folder located in my client's account. I have been granted access and I can see the folders in the web browser. However, I cannot make it happen to get data from the sharepoint folder with Power Query or Power BI. To make it more private I will use the example of this post, which is actually the same.  

 

I have tried: 

1) to directly point the folder:  https://powerbipanama.sharepoint.com/sites/externalsales/

2) to point the sharepoint: https://powerbipanama.sharepoint.com

 

With the following error message: "We couldn't authenticate with the credentials provided. Please try again."

 

I use my companies credentials which is a office 365 account.  Is it maybe that I do not have the proper credential granted to access my client's sharepoint? What are the credential I should have?

 

I need to access my client's files, the Sharepoint is my first idea if we can make it happen.

 

Thanks in advance! 

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous,

    You are able to access https://<site address>/sites/<sitename>/ in web Browser, right? If so,  do you use Microsoft account authentication in Power BI Desktop and do you choose the last level as shown in the screenshot below?



    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable

      Yes, exactly like that.

       

      I can see the files inside the sharepoint through a web browser but I cannot acess with power bi get data. I have no idea what is the problem. Any idea?

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        Anonymous,

        Are you in same domain as your client?

        Have you checked that if you are actually using the correct account in Power BI Desktop to sign in SharePoint? Please verify if other account and account password is cached in your web browser.



        Regards,
        Lydia

  • P_B's avatar
    P_B
    Frequent Visitor

    Hi There, 

     

    Were you able to find a solution to accessing the clients data in power bi when you don't have same domain credential. I am in the situtaion and curious to know if you were able to resolve it or find an alternate. 

     

    Thank you ! 

    • Anonymous's avatar
      Anonymous
      Not applicable

      No, i'm afraid not. In the end i always try to get a client's user so to do my job.