Forum Discussion
Http Get with specifying 'all' for a required field
Hi parry2k : Thanks for the help! Really appreciate it.
For those newbees like me:
-I had to change the function in advance editor-> to change NoticeId type from text to number and use Number.toText(NoticeId) in the url.
-Also I copied my master data source into a 2nd table, renamed it and kept only Id Column. Then selected this table to -'Add Column', 'Invoke Custom Function' step to bring a table of records for each row/ Id on this 2nd table. After expanding the Column-> I selected which fields I need to show up in this table.
-I then added a 'Notice Details' page, added drill-through feature with 'Id', had a 'Table' visual to show info from the 2nd table [giving me the info form my api#2].
-Now I can drill-through on 'Id' from my first page/ Notice Summary: for a specific row/Id-> I go to the 'Notice Details' page and see the Details for that Notice!
Voila! 🙂
Super UserAnonymous in a scenario like this, create a function which takes id as a parameter and then in the function constructs the URL, in your main table let's say you have 10 rows values 1 to 10, and let's say it I called id. Add a custom column and in this call the function and pass the id as a parameter value. and from there you expand this custom column which will append the data for all the ids.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Hi parry2k : Thanks for your response.
Since the data source is [not a db table/ file, but] an API portal, in my 'Get Data' stage: I am using Other-> 'Web' -> Advanced-> then have to specify the Web url . How can I specify the custom Column when I have not yet connected and pulled data from this data source/ Get Data? Best, Sohana