Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
1793aib
Helper I
Helper I

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 website 
 
https://      data.gov.au/dataset/ds-dga-7b8656f9-606d-4337-af29-66b89b2eeefb/details?q=asic
 
https://      data.gov.au/data/api/1/util/snippet/api_info.html?resource_id=5c3914e6-413e-4a2c-b890-bf8efe3eabf2
 
And the produce a table of the returned data - row per company.
 
I've tried to Web.Contents, etc.. but I just cannot get it to work.
 
These are some sample ACNs:
 
Company Number
3 REPLIES 3
1793aib
Helper I
Helper I

1793aib_0-1670280705945.png

 

But if I try and make it read a company name from a column, it says that it doesn't recognise 'Name'

 

 

1793aib
Helper I
Helper I

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-bf8efe3ea..." & "Calathea_Care_Pty_Ltd"))

 

KT_Bsmart2gethe
Impactful Individual
Impactful Individual

Hi @1793aib ,

 

try the link below: 

KT_Bsmart2gethe_0-1659708422465.png

 

It works for me.

 

Regards

KT

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors