locked
Sharepoint Lists / OData Connection to Sharepoint Lists RRS feed

  • 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