Power BI Service Trims Trailing Slash in Web.Contents Base URL – Causes API Error (LeafLink)

I'm encountering an issue while integrating LeafLink's API into Power BI using Web.Contents. Everything works fine in Power BI Desktop, but after publishing to the Power BI Service, the scheduled refresh fails with the following error:

DataSource.Error: Web.Contents failed to get contents from 'https://app.leaflink.com/api/v2/products/'  (400): Bad Request

In my M code, I define the base URL with a trailing slash, but it seems that when the query runs in the Power BI Service, the trailing slash is trimmed. This results in a malformed URL that the LeafLink API rejects. Question: Is this a known behavior/limitation with Web.Contents in Power BI Service where trailing slashes in base URLs are trimmed? If so, would Microsoft consider this expected behavior or something worth documenting?

Looking forward to any insights from the community or MS team!

Best regards,
Data IKseer

here is my M Code :

let
// Define the limit per page; adjust as needed.
limit = 100,
// Base URL for the API endpoint.
baseUrl = "https://app.leaflink.com/api/v2/products/",
// Your API token.
token = "XXXXXXXXXX",

// Function to fetch a page of data based on offset.
fetchPage = (offset as number) =>
let
query = [
limit = Number.ToText(limit),
offset = Number.ToText(offset)
],
Source = Web.Contents(
baseUrl,

Headers = [
#"Authorization" = "Token " & token,
#"Content-Type" = "application/json"
],
Query = query
),
JsonResponse = Json.Document(Source)
in
JsonResponse,

// Fetch the first page to get the total record count.
firstPage = fetchPage(0),
totalCount = firstPage[count],

// Generate a list of pages using the offset.
pages = List.Generate(
// Initial state: start with offset=0 and the first page.
() => [offset = 0, page = firstPage],
// Continue while the current offset is less than totalCount.
each [offset] < totalCount,
// Increment offset by the limit and fetch the next page.
each [offset = [offset] + limit, page = fetchPage([offset] + limit)]
),

// Extract pages from the state records.
// The first page is already retrieved; add the rest.
allPages = {firstPage} & List.Transform(pages, each [page]),

// Combine the results lists from each page.
// (If a page has no "results" field, it safely returns an empty list.)
resultsList = List.Combine(List.Transform(allPages, each try _[results] otherwise {}))
in
#"resultsList "