Dynamic Data Source Error and Power Query

[SisterRay]

I was working on fixing a dynamic data source issue and auto-refresh using the power bi service. 
I have changed the query using Web.Contents and RelativePath. But now I have an issue in desktop: "
We couldn't authenticate with the credentials provided"

(page as number, pagesize as number, from as text, to as text) as list =>

let
Source =Json.Document(
Web.Contents("portal.k3imagine.com/gw-bi/api",[Headers=[Authorization="Bearer "&token], RelativePath="v1.0/salesDetails",

Query=
[page=Number.ToText(page), pageSize=Number.ToText(pagesize), from = from, to = to]]))

in Source

Skript below works fine in Desktop:

(page as number, pagesize as number, from as text, to as text) as list =>

let
Source = Json.Document(Web.Contents(url & "salesDetails" & "?page=" & Number.ToText(page) & "&pageSize="& Number.ToText(pagesize) & "&from="&from& "&to="&to,
[Headers=[Authorization="Bearer "&token]]))
in
Source

Can anyone help with this issue? Thanks!

[SisterRay · Accepted solution]

I've fixed. The correct skript is below:

(page as number, pagesize as number, from as date, to as date) as list =>

let
url="https://portal.k3imagine.com/gw-bi/api/v1.0/",
Source = Json.Document(
Web.Contents(
url,
[
RelativePath = "salesDetails",
Query =
[
page=Number.ToText(page),
pageSize = Number.ToText(pagesize),
from = Date.ToText(from,"yyyy-MM-dd" ),
to=Date.ToText(to,"yyyy-MM-dd" )
],
Headers=
[Authorization="Bearer "& token]]))
in Source

[v-jingzhang]

Hi @SisterRay 

Have you tried the second script with the same Bearer token in Power BI Desktop? As the error message mentioned "credentials", maybe it's due to that the Bearer token has been expired. So first check if the token is still valid. 

Best Regards,
Community Support Team _ Jing

[SisterRay]

Yes. The second script works fine in the Power BI Desktop. But I try to optimise it for successful refresh in Power BI Service.