Web connector to SharePoint list works fine in Desktop but fails in Service

[Ashish560037]

Hi Everyone,

Any help on this issue is greatly appreciated. I'm connecting to a SharePoint list using Web connector. (Not using a Sharepoint list connectoras it takes too long to refresh data.) It works fine when I refresh the data in the Desktop version. 

But once I publish it to service, it throws the error whenever I try to update the credentials and thus wont refresh.

Please help.

[Ashish560037]

I tried the change mentioned in the link and it worked. Thanks Amine!!! You are a life saver...

[aj1973]

Hi @Ashish560037 

Tou use Web connector instead you need to copy/paste the Path of the file and not the Sharepoint URL.

[Ashish560037]

Hi Amine,

In the path, I'm giving the full path of the list in my M code as in "https://<mysitename>.sharepoint.com/sites/<mylistname>/_api/web/lists/getbytitle('"&listName&"')/items?""

Also, if there was an issue with the path, wouldn't it fail in Power BI dasktop as well? But in my case it works fine in desktop.

[aj1973]

This doesn't seem like a Sharepoint List to me !

Can you please share the M code?

To answer you question, the refresh can work fine in Desktop but fails in the service..

[Ashish560037]

Oh I didn't know that. Thanks for clarifying.

Here's the initial part of the M code where I connect to the list. The part after this is just selecting the columns. Hence not sharing that.

----

let 
    baseURL = "https://<sharepointsite>.sharepoint.com/sites/<subsite>",
    listName = "<listname>",
    GetPages = (Path)=>
        let
            Source = Json.Document(
                Web.Contents(
                    baseURL, 
                    [
                        RelativePath = Path,
                        Headers=[
                            Accept="application/json;odata=nometadata"
                        ]
                    ]
                )
            ),
            ll= Source[value],
            Next = Text.Replace(Source[odata.nextLink], baseURL, ""),
            result = try @ll & Function.InvokeAfter(()=> @GetPages(Next) , #duration(0,0,0,0.1)) otherwise @ll
        in
        result,
    
        Fullset = GetPages("/_api/web/lists/getbytitle('"&listName&"')/items?"

[aj1973 · Accepted solution]

Yes I see, please take a look at this, he had the same issue as you

Solved: Credentials for web conection are invalid (custom ... - Microsoft Fabric Community