Web.Contents failed to get contents from

[carloshluiz]

friends,
I'm having problems with my PBI to solve this problem, does anyone have any solutions?

An error occurred while processing the data in the dataset.
Falha na atualização:

Falha na atualização do New Dash.
Detalhes da falha: Web.Contents failed to get contents from 'https://gehealthcare-svc.my.salesforce.com/services/data/v48.0/query?q=SELECT%20Id%2CIsDeleted%2CMas... ' (414): URI Too Long
A próxima atualização do New Dash está agendada para quarta-feira, 26 de janeiro de 2022 15:00:00 UTC.

best regards

Henrique

[v-shex-msft · Accepted solution]

Hi @carloshluiz,

According to your snapshot, it seems like you add too long query string in the web connector URL.

For the query string parameters, we can add some simple filter conditions in the query string instead of a full query.

browser - What is the maximum possible length of a query string? - Stack Overflow
In my opinion, I'd like to suggest you contact the API developer if you need to send a long query. Then you can use send these queries to other parts of requests. (e.g. request header, body)

Regards,
Xiaoxin Sheng

[lbendlin]

As the message states - your query string is too long.  Ask for fewer columns.