Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi everyone,
I want to load data from a source with an variable hyperlink based on data from another query with project id.
Now I worked with a parameter:
let
Bron = Json.Document(Web.Contents("https://xxxxx/rest/projects/"&PM_Projecten_id, [Headers=[Authorization="Bearer xxx"]]))
This worked but now there is just one project loading into the new query. I want to load all the projects in te project.id column in the Power Query.
Can anyone give me some help.
Thanks!
Solved! Go to Solution.
You're on the right track. I think this Guy in a Cube video will give you the result your looking for:
https://www.youtube.com/watch?v=Z0U9UL9ORh8
You need to create a function (basically the script you already have with the parameter). Then you load the input value's in a list/table. The next step is to add the function in a column. It will then look at the value in column 1 (input values) and execute the function.
The guy in a cube video is based on nfl data over multiple seasons, but I think it can help you get the result your lookinf for.
Good luck!
You're on the right track. I think this Guy in a Cube video will give you the result your looking for:
https://www.youtube.com/watch?v=Z0U9UL9ORh8
You need to create a function (basically the script you already have with the parameter). Then you load the input value's in a list/table. The next step is to add the function in a column. It will then look at the value in column 1 (input values) and execute the function.
The guy in a cube video is based on nfl data over multiple seasons, but I think it can help you get the result your lookinf for.
Good luck!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.