powerbi connect to google bigquery shared dataset

SELECT
*
FROM
TABLE_DATE_RANGE([visitbasis1:archive_5833524659617792.visits_], DATE_ADD(CURRENT_TIMESTAMP(), -4, "MONTH"), CURRENT_TIMESTAMP())

SELECT
visitDate,
dayVisitsId,
visitId,
locationId,
location,
locationCode,
team,
userId,
nickname,
address,
proximity,
title,
division,
properties,
SUBSTR(STRING(timestamp), 9, 2) + ":" + SUBSTR(STRING(timestamp), 11, 2) + ":" + SUBSTR(STRING(timestamp), 13, 2) timestamp,
photoURL
FROM (
SELECT
visitDate,
dayVisitsId,
visitId,
customer.customerId locationId,
customer.name location,
customer.code locationCode,
mobileUser.tags team,
mobileUser.userId userId,
mobileUser.nickname nickname,
customer.address.street1 + IF(customer.address.street2 != "", ", " + customer.address.street2, "") + IF(customer.address.town != "", ", " + customer.address.town, "") + IF(customer.address.county != "", ", " + customer.address.county, "") + IF(customer.address.postCode != "", ", " + customer.address.postCode, "") + IF(customer.address.country != "", ", " + customer.address.country, "") address,
tasks.proximity proximity,
tasks.title title,
tasks.division division,
customer.properties properties,
MAX(tasks.tableRecords.photos.dateTime) timestamp,
GROUP_CONCAT(tasks.tableRecords.photos.imageReference.serviceURL) photoURL
FROM
[visitbasis1:archive_5833524659617792.visits]
WHERE
tasks.tableRecords.photos.dateTime IS NOT NULL
OR tasks.tableRecords.photos.imageReference.serviceURL IS NOT NULL
GROUP BY
visitDate,
dayVisitsId,
visitId,
locationId,
location,
locationCode,
team,
userId,
nickname,
address,
proximity,
title,
division,
properties)
ORDER BY
visitDate,
nickname,
location,
division,
title,
timestamp