Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.