Connecting Power BI to external Sharepoint datasource

[michael_Schmidt]

I am trying to connect to a client's sharepoint data files. The CFO granted me access to the files, therefore I can see them on line in the sharepoint site, however, I am not able to connect to the data through Power BI. I am being asked to provide credentials, which I have my own through my 365 subscription. Any solutions?

[SH_SL]

has anyone been able tofind a solution to this problem?

[Anonymous]

Hi  @michael_Schmidt ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[Anonymous]

Hi @michael_Schmidt ，

Did you get any error message when you try to connect to the files in Sharepoint? Which method you are using to connect to it? By Sharepoint folder or other connector?

Please review the following thread which has the similar requirement as yours, hope it can help you find something or solve the problem....

Connect to External SharePoint files from Power BI

your clients has to provide you with external access, described here: SharePoint and OneDrive integration with Azure AD B2B

---

Best Regards

[Daryl-Lynch-Bzy]

HI @michael_Schmidt 
When you are prompted to sign in as user, there is normally an option to "Use Another Account".  In the example, below, the first is my org SSO, the second should not go via another route where you have been granted guest access.  Have you tried this option?