Load Big Query table partitioned by date column

[Anonymous]

When I try to load a table via Big Query that is partitioned by date I get the following error

Can I filter somehow in the advanced editor to overcome this error?

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

You can create parameters in Power Query.

https://community.powerbi.com/t5/Power-Query/Connecting-Big-Query-tables-with-partitioning/td-p/387554

Parameters can be used either in UI or Advanced editor.

https://community.powerbi.com/t5/Desktop/Pass-parameters-to-Adcanced-Editor/td-p/344470

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.