Forum Discussion

kasife's avatar
kasife
Helper V
3 years ago

web.contents failed

Hi Guys, can someone help me understand and how to solve this problem? It was working normally, I made some changes to the power query and now it shows this error when loading.

 

 

(
    page
)
=>
let
    Fonte = 
        Json.Document(
            Web.Contents(
                "https://.cvcrm.com.br/", //Mantém o host da consulta
                [
                    RelativePath = "api/v1/cvdw/repasses", //Altera o RelativePath conforme deseja
                    Query = 
                    [
                        registros_por_pagina = "1000",
                       // a_partir_data_cad = "2022-01-01",
                        pagina = Number.ToText(page)
                        //limit = "1000" , // limite máximo de retornos por página é 1000. Testei mais e manteve-se no 1000.
                        //offset= Text.From(_offset)
                    ],
        
                    Headers = 
                    [
                        accept = "application/json",
    
                        email = _email,
                        token = _token
                    ]
                ]
            )
        )
in
    Fonte

 

Need Help

1 Reply

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    3 years ago

    Hi kasife ,

     

    The 422 (Unprocessable Entity) status code means the server understands the content type of the request entity (hence a 415 (Unsupported Media Type) status code is inappropriate), and the syntax of the request entity is correct (thus a 400 (Bad Request) status code is inappropriate) but was unable to process the contained instructions.

     

    In Power BI Desktop, this error Loading blocked by failures with other queries Power BI usually occurs in the following cases :

    1. The Datasource settings have been changed.
    2. The Datasource Path has been removed or changed in case, you are using Excel or CSV file.
    3. The Datasource path is correct but it’s too long.
    4. The file name is too long.
    5. One or more fields have been renamed or removed in your main data source.
    6. One or more steps have an error due to missing field names.
    7. The data type of one field or more has been changed.
    8. You’re using outdated data connectors, so you have to update the Power BI Desktop to the latest version.

    For more details, please refer to:

    Power BI: Loading Blocked By Failures With Other Queries | Microsoft Power Platform 

    422 Unprocessable Entity 

     

    Best Regards,

    Jianbo Li

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