Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to Solution.
Hi @jerryfalcobi
maybe this help.
let
searchText = "Power Query"
in
Web.Contents(
"https://www.bing.com",
[
RelativePath = "search",
Query = [q = searchText]
]
)
Hi @jerryfalcobi
maybe this help.
let
searchText = "Power Query"
in
Web.Contents(
"https://www.bing.com",
[
RelativePath = "search",
Query = [q = searchText]
]
)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 37 | |
| 28 | |
| 28 |
| User | Count |
|---|---|
| 124 | |
| 89 | |
| 73 | |
| 66 | |
| 65 |