Hello,
I would need some help to resolve an issue on my datasource.
I've a simple datasource that do a web request.
The request is done by a FetchPage functions that's look like this:
let
FetchPage = (url as text)
=>
let
jql= "project in ('TRAFRAMEWORK')",
contents = Web.Contents(url & "/rest/api/2/search?jql=" & jql,
[Query = [maxResults= "50", startAt = "0"],
Timeout=#duration(0,0,5,0)]),
json = Json.Document(contents),
Value = json[issues],
table = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
table
in
FetchPage
This functions is call by my main DataSource entry point "GetIssues" that look like this:
let
Source = FetchPageTest(URL),
in
#"Source"
When i do a Refresh on GetIssues in the power Bi Query Editor, all is ok.
If now I change the GetIssues entry point to expand the recors, something like this
let
Source = FetchPageTest(URL),
#"Column1D" = Table.ExpandRecordColumn(Source, "Column1", {"key"}, {"Column1.key"})
in
#"Column1D"
When I look for Web request emit by Power BI in a proxy interceptor like Fiddler, I coud see that in the first case, PowerBI only do one request.
In the second case, when I do the Expand, I can see that PowerBI do the same request twice !
Did I miss something in my request ?
Regards,
Laurent.
