Get 404 when connect SPO list from Power BI Desktop

--

Recently tried to pick up some Power BI skill. First thing I want to do is import the data from SharePoint online to BI.

In the program, I press “Get Data” > SharePoint, then input my sharepoint online list URL. Then I got below error:

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

The error is not useful. In fact it is because you should not input the LIST url. Instead, only input the site collection URL. i.e. https://xxxxxx/sites/xxxx/

Don’t input the suffix after “/sites/xxxx/”.

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

--

--

HK Power Platform Admin
HK Power Platform Admin

Written by HK Power Platform Admin

Cannot find SharePoint job. Switched to Power Platform.

No responses yet

Write a response