Connecting Big Query tables with partitioning

[ayrat]

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

[gbsarg]

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!

[v-yuezhe-msft · Accepted solution]

@ayrat,

You can define parameter in Power BI Desktop to solve the above issue.

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

Regards,
Lydia

[ayrat]

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