Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Credentials for web conection are invalid (custom conector for sharepoint)

So, yeah, another one about sharepoint and credentials. I searched the forum and the web in the last two days and couldnt find anything that could help me.   I have a report that reads data from a ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    I managed to make it work!


    I changed the parameter

    from https://client.sharepoint.com/sites/SiteName

    to https://client.sharepoint.com/sites/SiteName/_api.

     

    I deleted the published semantic model, configured on the desktop the credential and privacy as organizational on all connections (web and sharepoint), then republished it, put the web and sharepoint credentials as OAuth2 and privacy as oragnizational and skipped the test connection on web connector, and it worked!!

     

    In other words, all because of a "/_api".

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

Anonymous

Why don't you try to connect and import data differently ! :

  • Get data and use Sharepoint Online List connector and pick 2.0

     

  • if created delete all steps and start from Source

     

  • In Field "Title" filter your List

     

  • In Field "Items" click here to expand all Items(Or choose or Items)

     

  • From here you can start your ETL.

Carefull, do the test seperataly(New Query) and don't delete the steps applied already in the original import.

By the way you can add a new Query just to get the Id of the List and its Items(Comment, version,....) and then join it with the id of the list from the original Query in Model(Power BI Desktop) in case you don't want to delete the original Query.

 

Please let me know how it works out.

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I had already tried to find the versions of the items using 1.0 and 2.0.

In 1.0 there is a version column, but it shows the error below when I try to consult

In version 2.0, there is no version information.

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Sorry, but I don't think you are doing the right way. 1.0 and 2.0 are the versions of the connection and not the version of the Items. Use 2.0 version for connection and for "Items.Version" you should see it next to the title of your List

    Please follow my points in my previous reply. Delete all steps that were generated by the connector and filter your List as a first step

     

    You should see something like this after you expand field Items

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      aj1973 Maybe I expressed myself wrongly.
      Using the 2.0 implementation and expanded the items column, it has the current version of the item but not the previous ones, which is what my client wants to see

       

      Using the custom connector, I can get all versions


      Thanks.

       

      • aj1973's avatar
        aj1973
        Icon for Community Champion rankCommunity Champion
        2 years ago

        Looks like we don't have the same sharepoint structure. in mine , Versioning of the Item is represented in Item.ID with its date modified

         

        Anyway, you are welcome