Forum Discussion
Credentials for web conection are invalid (custom conector for sharepoint)
I managed to make it work!
I changed the parameterfrom 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".
Community Championaj1973, thanks for reply.
Both topics lead to the same link, which is a code in JQuery, which I was unable to adapt to the M language. They use a JS to make a AJAX request.
- aj1973
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.
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 consultIn version 2.0, there is no version information.
- Get data and use Sharepoint Online List connector and pick 2.0