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! đ
Hi parry2k : there are 2 options I thought of.
Option 1: I created a measure ABC Notice Detail Link = "https://apps.abc.com/natgasportal/notice/" & SELECTEDVALUE ('abc-notices_apiConnect'[Id] and
A âMoreâ button, by clicking on it- it goes to a web site that displays the ânotice detailsâ info. But it needs to create login access for n of users who will use the Dashboard.
So, thinking of Option 2: created a measure and the button, which I am hoping to connect to the Api portal[ note the difference in urls] and pull the notice details info in json/csv format and show it in a Visual on the Power BI dashboard.
The api url is like: https://api.abc.com/natgas/events/v1/notices/details?ids={ids}&format=csv [ changing the real name with âabcâ]
I have to change the measure I have come up with so far to use this url [for test I am using a simple version of this api w/o the format of the data]
Api Link for ABC Notice Detail = "https://api.abc.com/natgas/events/v1/notices/" & SELECTEDVALUE ('abc-notices_apiConnect'[Id] )
Option 2 doesnât need the login credentials for N number of users. But it needs the Api url [which I provided in the measure] and Api key, which donât know how to provide! Thanks.
Super UserAnonymous I think both these APIs should be called in Power Query and create this dataset (goes back to my original reply) and that way you can visualize the data in Power BI and don't need to click the external link to view the data, the dataset is prepared at the time of refreshing the data.
Reach out to me directly in case you need how to set this up. My email is in my signature.
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! đ