topic Re: Connecting PowerBI to a SharePoint Folder in Desktop

Connecting PowerBI to a SharePoint Folder

Pateen — Wed, 13 Mar 2019 14:09:02 GMT

Hi,

I am trying to connect to my organisations’' SharePoint account so I can retrieve CSV files as a Power BI data source.

I am using a SharePoint URL (i.e. https://mycompany.sharepoint.com/sites/GlobalDataRepository/DataStore)

to connect but I keep getting the following error below.

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)"

Its a share point online account.

Curiously I can sign in via an OData connection by using my organisational account but cannot connect to the sources. The returned error messages says we could not authenticate the credentials provided.

I have no problem logging into the site online itself via a browser.

I can also navigate and view the files I need by connecting via excel with a CSV connection but this is not the solution my organisation wants.

I have looked online here and elsewhere but cannot find the solution to resolve this.

Do I need to set up a gateway connection.

Any suggestions .... please?

Re: Connecting PowerBI to a SharePoint Folder

Pateen — Wed, 13 Mar 2019 18:00:04 GMT

I have now tried the web link

https://sonymusicentertainment.sharepoint.com/sites/GlobalDataRepository/DataStore/Forms/AllItems.aspx

and the URL

https://sonymusicentertainment.sharepoint.com/sites/GlobalDataRepository/DataStore

in both PBI desktop and Web Services and still get a permissions issue or the same message as above

Re: Connecting PowerBI to a SharePoint Folder

v-yulgu-msft — Thu, 14 Mar 2019 08:52:50 GMT

Hi Pateen ,

Please refer to my reply in this thread.

Regards,

Yuliana Gu

Re: Connecting PowerBI to a SharePoint Folder

Pateen — Fri, 15 Mar 2019 11:02:48 GMT

Hi v-yulgu-msft

Thanks for the reply.
I had a look through the thread and tried a few options such as try using the link from Windows Explorer, however the windows explorer is disabled in my classic view.

The thread you send appears to be more about merging multiple fields within a folder. My problem is much simpler; I just need access to the folder in the first place that I can already see in SharePoint.

One thing I noticed is I do have visibility to the base site i.e. https://mycompany.sharepoint.com. However, I cannot navigate from there.

Pat

Re: Connecting PowerBI to a SharePoint Folder

Pateen — Mon, 18 Mar 2019 17:52:54 GMT

Sorry should ahve said "merging multiple files within a folder"

So just struggling to connect to our data folder called:

https://mycompany.sharepoint.com/sites/GlobalDataRepository/DataStore

Re: Connecting PowerBI to a SharePoint Folder

Pateen — Tue, 19 Mar 2019 11:56:32 GMT

I wanted to clear up my terminology here and bit clearer in my problem
I now have visibility in PBI desktop to our base SharePoint website listed below.
I do this by navigating to -> get data ->SharePoint Folder and connecting to the following link.

https://mycompany.sharepoint.com/sites/GlobalDataRepository

However, data appears in here as source data rather than allowing me to navigate further.
This maybe because I picked “SharePoint Folder” option above
I need to go to a library called DataStore as per the link below

https://mycompany.sharepoint.com/sites/GlobalDataRepository/DataStore

In PBI web services, it is possible to navigate there by going to Create -> Data Sets -> Create New Content -> Files -> SharePoint Team sites -> entering the first link above.

I’ve tried getting data as a Text/CSV in PBI desktop by inserting the web address in the windows folder address bar but the error message returned says “Windows cannot find … Check Spelling”
I’m really doubt this cannot be this complicated but any help on this please …..

Re: Connecting PowerBI to a SharePoint Folder

Minseven — Tue, 19 Mar 2019 12:53:00 GMT

I don't get your problem. You need to connect on https://mycompany.sharepoint.com/sites/GlobalDataRepository

from there, you will have access to all the files listed in your sharepoint (included in DataStore)

click Edit as per screenshot and select and combine your data:

If you still have an access problem, please reset your credential: File > options & Settings > Data source settings

Clear then permissions and reconnect using Microsoft Account by logging in by using the same level to apply the setting (https://mycompany.sharepoint.com/sites/GlobalDataRepository)

Re: Connecting PowerBI to a SharePoint Folder

Pateen — Tue, 19 Mar 2019 14:20:13 GMT

Thanks for your reply Minseven ,

I can see the same information you have shown me when I connect to on side.

I can view the filenames, extention, Dates, Folder names etc.

The problem is I want to access whats inside the files themslves (csv & txt data) and not just have information about the files.

I've tried various other methods (OData, CVS, etc) to getting this data on our sharepoint site but again run into the same problem.

Like I was saying, its a very simple problem whihc I just cannot seem to solve.

Any ideas at all

Pateen

Re: Connecting PowerBI to a SharePoint Folder

Minseven — Tue, 19 Mar 2019 14:30:34 GMT

If you can see it (screenshot) you can access it!

click Edit. In new screen > filter by your file names (Thats's why naming your data is important here) > Then combine your file:

Re: Connecting PowerBI to a SharePoint Folder

Pateen — Wed, 20 Mar 2019 11:40:42 GMT

Thanks you Minseven

That works perfect

Re: Connecting PowerBI to a SharePoint Folder

juresti — Thu, 26 Sep 2019 13:51:30 GMT

Hi,

I was also experiencing the same issue where I am connecting to sharepoint from powerbi online and it stated I may not have permissions to it or that it may have been removed.

It turns out that I needed to wait a about 5 minutes for all the servers to refresh apparently.

Now I have a completely online solution where I can connect to csv files in sharepoint from power BI online service.