Forum Discussion

caioalencikas's avatar
caioalencikas
Regular Visitor
4 years ago
Solved

Wrong dataset/project in Big Query

Hello,

 

I'm connecting to a BigQuery project. In the Power BI Desktop is working fine, I can connect, work with the Power Query, everything is fine. In the "Advanced Editor", everything is okay, source name, schema name and table name. (Print below)

 

 

But then I published to the Power BI Online, I can see the report, that's fine. But when I try to update I am getting this error (below). I connect to the BigQuery via OAuth with my login. But I have access to two project here in my company. The Power BI is getting the wrong project/dataset and then it cannot find my table.

 

How can I manage what is the project/dataset that I want to connect in Power BI Online, since in Power BI Desktop everything seems fine?

 

ODBC: ERROR [42S02] [Microsoft][BigQuery] (31770) Table is not found. Not found: Table "wrong_dataset":"table_name" was not found in location US 

 

 

2 Replies