Capturing latest table name and used in powerbi native query

[Anonymous]

Details –

Need to extract all tables from the schema

Identify the latest table based on date attached at end of the table name

Extract the data from POWRBI using the latest table

tables available as below in schema.

Steps performed below to achieve the results, but I’m unable to capture the tablename in parameter to utilize in Query2 PowerBI. Any help is appriciated 

Query1 – Query used to pick the latest table then converted to list

Parameter – Used to capture value from the Query1

Query2 – used to get all records from the latest table name passed from parameter.

Query1- Created this to identify the latest table name, then Converted this Query1 to list

Parameter – Used capture the result from Query1 using query option, screenshot below.

Query2 – Used to get all records from the latest table name, passed parameter as highlited below.

[Anonymous]

That's controlled in the program options, under security, I think. 

[Anonymous · Accepted solution]

I would make a new query named LatestTable, and in the formula bar, type:

= List.Max(Table_Name)

Then, in the advanced editor, make it so that your SQL is like:

Query = "SELECT TheFirstPart.OfYourTable_"&LatestTable&" as tablename from all_tables where owner = 'What_Ever' and table_name like 'Something'"])

--Nate

[Anonymous]

thank you so much and it's working as expected. But i would like to know when we schedulle this report in service daily, the below popup will taken care by automatically or not. Beacuser every day our query is the new one..