9
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.
STATUS DETAILS
Planned
2021 Release Wave 1