Can connect to Sharepoint Folder, but don't see my file

[mmace1]

Hi, 

I've connected to Get Data > Sharepoint folder, can see many of our files - but not the one I'm looking for.  

I enter the URL in this format:

https://mycompany.sharepoint.com

The actual URL of my file is something like:

https://mycompany.sharepoint.com/:x:/r/teams/PaymentAnalysisReportReviews/_layouts/15/Doc.aspx?sourc......

Am I feeding Get Data > Sharepoint the wrong URL? 

I've also tried Get Data > Web, but then start running into authentication errors - and searching on those leads down a black hole of PBI-Sharepoint issues.  I'm able to authenticate with Get Data > Sharepoint Folder so...want to try to figure out that route first. 

Thanks!

[v-juanli-msft · Accepted solution]

Hi @mmace1 

I make a test succefully following the link

https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/

Use the following link format instead

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mmace1]

Thanks!  The instructions from that link worked. 

What helped was "Clicking on the Home in the left navigation will take you to the home location of the SharePoint site. " - and using *that* URL. 

So Get Data > Sharepoint Folder, then feeding it, in my case, a URL like this: 

https://MyCompany.sharepoint.com/teams/PaymentAnalysisReportReviews