Forum Discussion
Power BI Get Data From Multiple Google BigQuery Projects
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-projects
2 Replies
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-Lag0VOiTsAs I said and can confirm that this is related to multiple Google BigQuery projects issue.
