credentials are now required for new queries in dataflows even though the same query works elsewhere

[zayne]

I've been trying to copy a query from one dataflow to another so that I can use it to filter the table in that dataflow, but I'm getting the issue below:

"Credentials are required to connect to the Web source. (Source at https://xxxxxxxxxxx/api  )

Every time I try to verify the credentials, I'm shown this:

When I do so, I'm just taken back to the query with the same message shown above: 

If I try to create a new connection, I get this.

I don't understand this, because the query is working in the other dataflow, and I'm simply copying it to another dataflow. The query uses a parameter for the APIKey. I've copied that across too. 

let
  BaseURL = "https://xxxx.xxxxx/api/v1/",
  Entity = "xxxxxx",
  Source = Json.Document(
    Web.Contents(
        BaseURL,
        [
            RelativePath = Entity,
            Query = [
                        api_token = APIKey,
                        filter_id = "754",
                        limit="1",
                        start="0",
                        get_summary="1"
                    ]
        ]
    )
),

It seems like this is an issue with the service that has cropped up.

[KNP]

Hi @zayne,

I'm having the same issue, oddly, the exact same code is working in other environments.

Did you manage to solve this?

@Anonymous - if you have access to the product team relating to Dataflows, can you ask them...

"Has something changed in the service that prevents Web.Contents working in dataflows with Anonymous auth?"

"Are there any known issues with Web.Contents specifically in Dataflows?"

I'd love to know if this is due to changes and going to extend to other environments because I'm going to need to build a fix if this is the case.

[zayne]

Thanks for posting. However, none of these are related to my issue.

[Anonymous]

Hi  @zayne ,

This is the related document, you can view this content:

Solved: Web.Contents throws error when trying to pass toke... - Microsoft Power BI Community

Help... please! Credentials are required to connec... - Microsoft Power BI Community

Credentials provided for the Web source are invalid - PowerBI - SharePoint Views

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.