Forum Discussion
Pass a particular value from a dashboard via Rest API call
Current Power BI report has a data in tabular format. Customer ID is displaying some value as a hyperlink. How to pass a particular value (for example: customer ID, name) in a dashboard which will send a rest API call.
Hi Kiran1234 ,
If the hyperlink contains the needed information, you can extract them as single columns to store customer ID, names etc. , then create lists for each extracted column in Power Query so that you can create parameters from the lists and pass it to a API query.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Not totally clear on your scenario, but you can start with a table that has CustomID column, concatenate that into a url string that can be used in a Web.Content( ) REST API call.
Pat
Hi Kiran1234 ,
If the hyperlink contains the needed information, you can extract them as single columns to store customer ID, names etc. , then create lists for each extracted column in Power Query so that you can create parameters from the lists and pass it to a API query.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
