Mimoune Djouallah on 26 Oct 2020 00:23:11
PowerBI added recently M Query support for BigQuery, this is a great achievement see example here
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/
but unfortunately without the support for Native Query, there are a lot of complex scenario where we can not simply use it by using PowerQuery interface, as it is limited by Query Folding.
it will be really great to have the option to create a Custom SQL Query that use the new M Parameter.
Administrator on 18 Apr 2022 20:32:36
2021 Wave 1 Release Item - https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave1/data-integration/google-bigquery-connector-native-query-support