Power BI Get Data From Multiple Google BigQuery Projects

[iqb]

I have 2 projects in Google Big Query.

select * FROM `project1.analytics_1.Table1`

select * FROM `project2.analytics_2.Table2`

When I get data from Google Big Query, the first one works but for the second one I am getting `The key didn't match any rows in the table`.

https://i.stack.imgur.com/cu1Kd.png

Asked the same question on SO at https://stackoverflow.com/questions/75501923/power-bi-get-data-from-multiple-google-bigquery-project...

[amitchandak]

@iqb , This is usually when some column is missing or there is data type change step and it does not fine that column name

Open the power query and  check the steps

You can also, try clear permission of the data source and try again

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s


refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

[iqb]

As I said and can confirm that this is related to multiple Google BigQuery projects issue.