Connecting Big Query tables with partitioning

I have a database which contains a table named app_events. App_events table uses partitioning based on dates. As a result, every day I get a new table with naming app_events_YYYYMMDD. 

When I query this table I can use a query using a wildcard like app_events_*, so every partition will be queried. 

To connect the same table in Power BI I need to check each partition in Navigator menu. Also, next day I should manually append new partition to reports database. 

Is there any other solution to automate this process?

#Google, #BigQuery, #Partitioning

Hi ayrat, 

Did you manage to solve your issue using parameters? Would you please post a brief step by step tutorial? I am having the exact same issue and cannot figure it out. 

Thanks!