Forum Discussion
Power BI (Query) and ASIC Company Number Search
I'm stuck trying to search Company Numbers (ACNs) from the web. I've connected my BI to a database of clients, one column is the Company Number (ACN). I want to take that ACN, pass it to this...
I could get it to add a column and search if I hard code the name into the Power Query Line
= Table.AddColumn( #"Replaced Value1","ACNCheck", each Web.Contents("https://data.gov.au/data/api/3/action/datastore_search?resource_id=5c3914e6-413e-4a2c-b890-bf8efe3eabf2&q=" & "Calathea_Care_Pty_Ltd"))