Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
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
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
Yes. The second script works fine in the Power BI Desktop. But I try to optimise it for successful refresh in Power BI Service.