issue with backslash in query

Question

Hi all, If i use relative path in my power query i have some trouble with a backslash. In this case i have a web API like https://thewebsite.com:8800/data? when i use as source https://thewebsite.com/ and as RelativePath=":8800/data?" the query editor adds a backslash between the com and :8800. How can i remove that backslash?
I want refresh the data automatically. Thats why i use the relativepath

raywu · Accepted Answer

Hi&nbsp;jerryfalcobi&nbsp;maybe this help.https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/let
    searchText = "Power Query"
in
    Web.Contents(
        "https://www.bing.com",
        [
            RelativePath = "search",
            Query = [q = searchText]
        ]
    )&nbsp;

Forum Discussion

issue with backslash in query

1 Reply

Related content

Fabric notebook backslash issue

Authentication and Query issues - cannot authenticate, queries hang

SQL Query Syntax issue

Direct Query issue with Snowflake

Power Query in Excel issue