Answered by:
Sharepoint Lists / OData Connection to Sharepoint Lists

Question
-
Hello<o:p></o:p>
To retrieve information from a set of sharepoint lists we have stablished an O Data Connection with Organizational Account.<o:p></o:p>
We are currently unable to access sharepoint lists information due to the error “the user was not authorized”<o:p></o:p>
Is there something that changed last week or that we should do to make sure the authentication works?<o:p></o:p>
Appreciate anyone’s guidance as this is an urgent issue.<o:p></o:p>
Kind Regards,<o:p></o:p>
Leo3472<o:p></o:p>
- Edited by Leo3472 Sunday, May 15, 2016 7:29 PM
Sunday, May 15, 2016 6:05 PM
Answers
-
Hi Leo. Does this address the issue you're seeing?
http://community.powerbi.com/t5/Desktop/Power-BI-Refresh-Time-using-Sharepoint-OData-Form-Library-Source/m-p/33372#M11819
Ehren
- Marked as answer by Leo3472 Tuesday, May 17, 2016 2:07 AM
Monday, May 16, 2016 10:35 PM
All replies
-
They did release a new "SharePoint Online List" connector for Power Query in Desktop, are you using Desktop or Excel or ?Monday, May 16, 2016 12:36 PM
-
Hi Greg,
Thanks for your reply.
Yes, we use Power Query add-in for Excel.
The SharePoint Online List connector takes a long time to retrieve the data and the OData connector has always worked fine but now randomly produces the mentioned error as if the authentication would fail for no reason.
:(
Monday, May 16, 2016 12:56 PM -
Hi Leo. Does this address the issue you're seeing?
http://community.powerbi.com/t5/Desktop/Power-BI-Refresh-Time-using-Sharepoint-OData-Form-Library-Source/m-p/33372#M11819
Ehren
- Marked as answer by Leo3472 Tuesday, May 17, 2016 2:07 AM
Monday, May 16, 2016 10:35 PM -
Thank you Ehren!!
The OData is another issue but I can now replace the connector from OData to Sarepoint Lists Connector without getting the error message :)
Tuesday, May 17, 2016 2:07 AM