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.
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.
@Anonymous
As I understand, operations like "expand columns" will make the Power Query Engine recompute the a new query which will hit another web request. For more details about how Power Query engine works, please refer to a thread below:
Regards,
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.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |