Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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!
@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
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