Get Limited data in Power BI

This could be tricky if you have lots of IDs and data. The ideal would to have the list in the source server so you can use the database engine to filter before sending the data.

3 options I can think of are.

1) if the ID list is short create a string and build a sql command based on this in M,

e.g. IDS  IN ( 3,23,56,73,86 )

wr_rfa_IDS is your csv data

let
   
    Transposed = Table.Transpose(wr_rfa_IDS),
    MergedIDS = Table.CombineColumns(Table.TransformColumnTypes(Transposed , {{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}}, "en-GB"),{"Column1", "Column2", "Column3", "Column4", "Column5"},Combiner.CombineTextByDelimiter(",", QuoteStyle.None),"Merged"),

    SQLText = "SELECT TOP (1000) start_step_id, job_id#(lf)  FROM [msdb].[dbo].[sysjobs]#(lf) 
    where start_step_id in (" & MergedIDS[Merged]{0} & ")",
    Source = Sql.Database(Server, Database, [Query=SQLText])
in
    Source

2) create a function for the retreival of each id and merge the results

fnGetIDData

let
    Source = (TextIDValue as text) => let
    SQLText = "SELECT TOP (1000) start_step_id, job_id#(lf)  FROM [msdb].[dbo].[sysjobs]#(lf) 
    where start_step_id = " & TextIDValue & " ",
    Source = Sql.Database(Server, Database, [Query=SQLText])
in
    Source
in
    Source

let
    Source = wr_rfa_IDS,
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"wr_rfa_IDS", type text}}),
    #"Invoked Custom Function" = Table.AddColumn(#"Changed Type", "Data", each fnGetIDData([wr_rfa_IDS])),
    #"Expanded Data" = Table.ExpandTableColumn(#"Invoked Custom Function", "Data", {"start_step_id", "job_id"}, {"Data.start_step_id", "Data.job_id"})
in
    #"Expanded Data"

So this loops through the ids bring an ID at a time.

 3) Try and get the query folding to limit the rows.

Not sure if this will work but it you pull a full table

let
    Source = Sql.Database(Server, Database),
    dbo_MSdbms_datatype_mapping = Source{[Schema="dbo",Item="MSdbms_datatype_mapping"]}[Data],
    #"Filtered Rows" = Table.SelectRows(dbo_MSdbms_datatype_mapping, each ([map_id] = 6 or [map_id] = 10 or [map_id] = 13 or [map_id] = 24 or [map_id] = 26 or [map_id] = 44 or [map_id] = 46 or [map_id] = 59 or [map_id] = 60))
in
    #"Filtered Rows"

and filter it

The query folding then applies a filter to the sql run on the server.

select [_].[datatype_mapping_id],
    [_].[map_id],
    [_].[dest_datatype_id],
    [_].[dest_precision],
    [_].[dest_scale],
    [_].[dest_length],
    [_].[dest_nullable],
    [_].[dest_createparams],
    [_].[dataloss]
from [dbo].[MSdbms_datatype_mapping] as [_]
where ((([_].[map_id] = 6 or [_].[map_id] = 10) or ([_].[map_id] = 13 or [_].[map_id] = 24)) or (([_].[map_id] = 26 or [_].[map_id] = 44) or ([_].[map_id] = 46 or [_].[map_id] = 59))) or [_].[map_id] = 60

So it may be possible to apply your list of ids in a way that allows query folder to work for you. Note it's easy to do something to stop query folding working.

These posts may help

https://www.mssqltips.com/sqlservertip/3635/query-folding-in-power-query-to-improve-performance/

https://blog.crossjoin.co.uk/2017/06/11/query-folding-and-writing-your-own-sql-queries-in-power-querypower-biexcel-get-transform/