Reply
Regular Visitor
Posts: 21
Registered: ‎04-03-2017

Re: Can't connect to Sharepoint subsites using PowerBI

@Ross73312 Well that is the problem. In PBI Desktop if i specify the full path i get the error that i've posted. In PBI Desktop i can only specify https://companyname.sharepoint.com/Site1/ for it to work.

 

BR,

Andrei

Senior Member
Posts: 287
Registered: ‎02-28-2017

Re: Can't connect to Sharepoint subsites using PowerBI

Ok i've run some testing this morning, coincedently because a staff member also needed to do this today.  Here is what we did and it worked.

Select new data source and choose "SharePoint Folder" or "SharePoint List" depending on what task you are performing.  Choose https://companyname.sharepoint.com/Site1/ and then locate the files/lists as they appear in this list.  Everything should be in here for Site1.  On mine there is a "Folder Path" column which might help you filter down.

Regular Visitor
Posts: 21
Registered: ‎04-03-2017

Re: Can't connect to Sharepoint subsites using PowerBI

@Ross73312 this is what i get if i try to reproduce your steps (sharepoint folder).

There is no possibility to drill down to subfolders from here. It just retrieves some nonsense data.

 

Does it have anything to do with the structure of the sharepoint folders/subfolders etc?

The weird thing is that in app.powerbi.com works just fine...

 

Capture.JPG

 

If i choose sharepoint list i get the following screen.

I can check/uncheck the subsites on the left side, but the information in it is nonsense, i should be able to browse to those subfolders and select a worksheet.

 

Capture.JPG

 

BR,

Andrei

Highlighted
Senior Member
Posts: 287
Registered: ‎02-28-2017

Re: Can't connect to Sharepoint subsites using PowerBI

It depends whether you are using Lists or Files.  Based on your original description, files will be what i imagine you need.

Have another look at your files list and there should be a column called "Folder Path".  You should be able to use this to find the files in your subfolders.  Essentually all of the files are there in that single list.

Regular Visitor
Posts: 21
Registered: ‎04-03-2017

PBI Desktop connection to sharepoint online

Dears,

 

I've been struggling in the past week to connect PowerBI Desktop to sharepoint online to extract some data from excels.

 

I've encountered the following problem:

 

  - When connecting to the sharepoint site https://company.sharepoint.com/Site cannot browse further my companys subsites in order to select the data that i need. I get the following screen:

 

Capture.JPG

 

In this screen if i select the subsites on the left i get nonsense data in the right. My data should be in these subsites in the form of excels.

 

If i try to connect directly to the subsite i get the following error:

 https://company.sharepoint.com/Site/Subsite

Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Not Found)"

 

If i type in the full path of my folder i get the following message:

 

 

Capture.JPG

 

The weird thing is that if i follow the same steps in app.powerbi.com i get a screen in which i can browse my subsites/folders and get my data.

 

I want to do this in PBI Desktop, not Web.

 

Any thoughts?

 

I'm mentioning that i have the latest version of PBI Version: 2.45.4704.722 64-bit (April 2017)

 

 

BR,

Andrei

 

Moderator
Posts: 2,534
Registered: ‎03-10-2016

Re: PBI Desktop connection to sharepoint online

Hi @avelio,

Navigate to the home page of your subsite in browser, then copy the URL which is like: https://XXXX.sharepoint.com/sites/patrick/team1/SitePages/Home.aspx, then exclude “/SitePages/Home.aspx” part from the URL and  enter URL like https://XXXX.sharepoint.com/sites/patrick/team1 in SharePoint connector in Power BI Desktop.
1.PNG

 

Thanks,
Lydia Zhang