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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
maracles
Resolver II
Resolver II

Using a table column as a list of values for a parameter

I am learning to use parameters and I want to use them to make scraping data from IMDb easier. 

I want to pull in a couple of fields of data per film (release date, country and director) from IMDb and I have a table, one of the columns of which is IMDB ID. 

From there I have created a new source from Web and have used url parts  to identify the film ID that needs change per query. 

See below:

imdb Source.png

I have then created a parameter called IMDB ID which I want to use to populate this URL. See below:

 

 

imdb parameter.png


My issue is that I don't want to manually have to add every IMDB title ID to this list of values in the parameter. Instead I have an existing table which contains data imported from a workbook. One of the columns on this table is IMDB ID. Is there no way that I can use this dynamically changing table column to populate the list of values?


1 ACCEPTED SOLUTION
v-xjiin-msft
Solution Sage
Solution Sage

Hi @maracles,

 

=> Instead I have an existing table which contains data imported from a workbook. One of the columns on this table is IMDB ID.

 

To create a parameter and give it values from this column. You can refer to following steps:

 

1. Go to Edit Queries, choose the IMDB ID column, go to Transform -> Convert to List. Then you'll get an signle list with IMDB ID values. Please be noticed, if you want to keep original table, duplicate a table before doing convert. Also you can remove duplicates inside this column. Please refer to following sample:

 

 Original TableOriginal TableConvert column RecordType to List and remove duplicatesConvert column RecordType to List and remove duplicates

2. Create a new parameter, set the Suggested Values to Query (the list we generated above), and give a default value.

 

3.PNG

 

3. Close&Apply. Then you can see all the values in the column are in the drop down box of this parameter.

 

4.PNG

 

Thanks,
Xi Jin.

 

 

View solution in original post

2 REPLIES 2
v-xjiin-msft
Solution Sage
Solution Sage

Hi @maracles,

 

=> Instead I have an existing table which contains data imported from a workbook. One of the columns on this table is IMDB ID.

 

To create a parameter and give it values from this column. You can refer to following steps:

 

1. Go to Edit Queries, choose the IMDB ID column, go to Transform -> Convert to List. Then you'll get an signle list with IMDB ID values. Please be noticed, if you want to keep original table, duplicate a table before doing convert. Also you can remove duplicates inside this column. Please refer to following sample:

 

 Original TableOriginal TableConvert column RecordType to List and remove duplicatesConvert column RecordType to List and remove duplicates

2. Create a new parameter, set the Suggested Values to Query (the list we generated above), and give a default value.

 

3.PNG

 

3. Close&Apply. Then you can see all the values in the column are in the drop down box of this parameter.

 

4.PNG

 

Thanks,
Xi Jin.

 

 

Thanks @v-xjiin-msft,

Your steps have worked to list values in the parameter,so I've marked it as the answer.

Unfortunately it seems that I cannot use that method as "Formula.Firewall: Query 'Additional Details' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."

So I will need to find an alternative way to scrape the data. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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