How can I edit the query SQL when I'm using the BigQuery connector?
The bigQuery connector just allow me to select a table, but I need to make a different sql to correlate 2 tables with several gigabytes of data. The result has only 3800 rows and that is what I want to bring to powerBI.
ODBC is NOT and option.
Can I edit the SQL in PowerQuery advanced editor for the BigQuery Connector?