Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
hello
I am trying to Invoke a function that is pulling data from an API. The function takes IDs from the table where I am adding the column.
Here is my function
let
Source =(ID_1, ID_2 as text) => let
Source = each Json.Document(Web.Contents("https://fake.api.com/v3/rest/fake1/" & ID_1 & "/fake2/" & ID_2 & "/fake3?limit=1&offset=0" , [Headers=[Authorization= "Bearer myapikey"]])),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
#"Converted to Table"
in
Source
the table is like this
ID_1 | ID_2 |
6e9e7742-d651-44f6-b2a1-6d1edcd94ace | 17e61aba-19f1-49d6-a07c-aa0085b38b5f |
c89f89b2-bfd6-4984-b672-ad3f20a1fb8c | a4f06500-2a2a-4318-a9ab-bfeae705e7d3 |
I get this error message when invoking the function
Expression.Error: We cannot convert a value of type Function to type List.
Details:
Value=[Function]
Thanks
Joe
Type=[Type]
Solved! Go to Solution.
By removing the "each" before Json.Document helped it work
By removing the "each" before Json.Document helped it work
User | Count |
---|---|
59 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
78 | |
62 | |
45 | |
40 | |
39 |