Forum Discussion
Connecting PowerBI to a SharePoint Folder
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?
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:
10 Replies
I have now tried the web link
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
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.
PatSorry 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
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.
