cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rgparisoto Frequent Visitor
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

Thank you @djeepy1! I'll try this model.

Regards,

rgparisoto Frequent Visitor
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

Hi @djeepy1! The Power Bi return me this:

"The User was not authorized"

 

2016-07-01_15-13-58.png

 

I don't know how to fix it. Smiley Sad

djeepy1 Frequent Visitor
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

If you test the URL in a browser (being previously logged in O365), does it work ?

Jean-Pierre Riehl
MVP Data Platform
rgparisoto Frequent Visitor
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

Yes @djeepy1!

It works.

djeepy1 Frequent Visitor
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

When you type URL in OData feed, Power BI Desktop should prompt for authentication (O365 windows). Be sure to choose OAuth authentication.

 

Can you verify you have the lastest version of PBI Desktop ?

Did you use the OData Feed source in Get Data menu ?

You can also check on in Data Source Settings window if Authentication is correct.

 

JP

Jean-Pierre Riehl
MVP Data Platform
sAlexRUS Visitor
Visitor

Re: Connecting to a SharePoint List Office 365 error

Tell me please
Why does not this request?

 

let

    soursOData = Data.Feed("https://<app web url>/_api/web/Lists(guid'DEE5D045-C8AB-4878-B3F1-0D814EBF648E')/Items?$select=TextMonth,TextQuarter")

in 

  soursOData

 

ErrorSP_1.PNGError OData.Feed

P/S/

This code is working in the browser

djeepy1 Frequent Visitor
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

You get a HTTP 404 error on /$metadata resource of your list on your SharePoint.
I'm not a SharePoint expert but maybe there's some specific setting on your list (or permission missing).
Jean-Pierre Riehl
MVP Data Platform
a0199847 Frequent Visitor
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

I am getting this error:  DataSource.Error: OData: The feed's metadata document appears to be invalid.  I noticed other people are getting it.  Is there any other solution to this problem that might work?  I have been trying to work around the error all morning!

a0199847 Frequent Visitor
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

I am getting this error:  DataSource.Error: OData: The feed's metadata document appears to be invalid.  I noticed other people are getting it.  Is there any other solution to this problem that might work?  I have been trying to work around the error all morning!

phammk Frequent Visitor
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

let
  origem = OData.Feed("http://xxxxxxxx/_api/Web/Li​sts(guid'FEF2602C-661B-4268-8056-1CC347B21489')/Items?$select=Accomplishments,ADDepartmentCPMO")
in
  origem

 

Give me this error

 

DataSource.Error: Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (400) Bad Request. (The expression "Web/Li​sts(guid'FEF2602C-661B-4268-8056-1CC347B21489')/Items" is not valid.)
OData Version: 4, Error: The remote server returned an error: (400) Bad Request. (The expression "Web/Li​sts(guid'FEF2602C-661B-4268-8056-1CC347B21489')/Items" is not valid.)
OData Version: 3, Error: The remote server returned an error: (400) Bad Request. (The expression "Web/Li​sts(guid'FEF2602C-661B-4268-8056-1CC347B21489')/Items" is not valid.)
Details:
    DataSourceKind=OData
    DataSourcePath=http://xxxx/_api/Web/Li%E2%80%8Bsts(guid&#39;FEF2602C-661B-4268-8056-1CC347B21489&#39Smiley Wink/Items
    SPRequestGuid=5714d39d-8fd8-b0bc-319d-ee537d33ffb1, 5714d39d-4fe3-b0bc-319d-e42451efe2a8, 5714d39d-0fee-b0bc-319d-eecf29d902df

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 281 members 2,595 guests
Please welcome our newest community members: