Need help whit web data source advanced options

[CodeBernardo]

I'm working on an integration with Power Bi, where I have an automation that decides which Api I should call to read the data. In Power Bi, I select that the data source will be from the web and pass the link to my automation webhook along with 2 headers necessary to validate and search for the correct endpoint of the request, User Key and Api Key. However, Power Bi is omitting this information and I have difficulty understanding why.

That's the way I'm making the call:

And this is what is coming to my service:

Some things I noticed is that if I pass a short key it receives the data, however when I pass the real service keys, which are in GUID format, the data is omitted, is there a string size that I must respect?

[CodeBernardo · Accepted solution]

Hello, thanks for responding, I found another way to get the result I wanted, I had to send the data I wanted through query params, from what I understand power bi has problems with the "-" character, in general, if the header contains more than one "-", it omits the key, but via query it accepts it.

[Anonymous]

Hi @CodeBernardo ,
According to your description, it will take effect when you enter shorter characters and will not respond when you enter longer characters. This could be due to your long GUID or a command timeout. One way is that you can shorten your GUID, or set the command timeout in the advanced interface.

Power Query Web connector - Power Query | Microsoft Learn
Web.Contents - PowerQuery M | Microsoft Learn

Best regards,
Albert He

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