Why is %29 in a URL Encode to ) During a Request?

Hi Everyone, I encountered an issue while working with a direct download URL in Power Query using the Web.Contents function. The URL contains an encoded value %29 (which represents a closing parenth...

General Comment

Interesting Links

Need Help

Tips and Tricks

v-csrikanth
1 year ago
Hi Suraj_Ncircle
While encoding the entire URL using Uri.EscapeDataString in PQ is problematic because Web.Contents expects a valid absolute URL and may not properly handle fully encoded URLs.
However, we can work around this by constructing the request in a way that ensures encoding remains intact.
Manually encoding the entire URL:
***************************************************************
let
BaseUrl = "https://cdn.Domain.com/dXJuOmFkc2sud2lwcHJvZDpmcy5maWxlO_dmVyc2lvbj0x/output/Resource/3D%20View/2_%2...",
Cookies = "your_cookie_data",
EncodedUrl = Uri.EscapeDataString(BaseUrl), // Encode the entire URL
QueryResponse = Web.Contents(EncodedUrl & Cookies, [Headers=[#"Accept"="application/json"]])
in
QueryResponse
***************************************************************
After giving a try if still the issue persists. Could you please follow below link to raise a support ticket
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

If the above information helps you, please give us a Kudos and marked the reply Accept as a Solution.

Thanks,
Cheri Srikanth

Suraj_Ncircle

Frequent Visitor

1 year ago

Thank you for following up. I tried the solution provided by BeaBF , but unfortunately, it didn’t resolve the issue. It seems that Web.Contents is unable to interpret %29 correctly. Specifically, we receive the encoded value %29 for 분) from the client server, but when the URL is processed, Web.Contents appears to interpret %29 as a closing parenthesis ).

I would appreciate any further guidance or suggestions to address this issue. Thank you for your understanding.