Forum Discussion
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
Hi, caioalencikas ‘
Have you tried to set Authentication Method to ’Basic‘?
Please follow the tutorials below:
Visualize Live BigQuery Data in the Power BI Service
Import BigQuery Data into the Power BI Service for Visualizations
Best Regards,
Community Support Team _ Eason
2 Replies
- v-easonf-msft
Community Support
Hi, caioalencikas ‘
Have you tried to set Authentication Method to ’Basic‘?
Please follow the tutorials below:
Visualize Live BigQuery Data in the Power BI Service
Import BigQuery Data into the Power BI Service for Visualizations
Best Regards,
Community Support Team _ Eason- caioalencikasRegular Visitor
I tried with Authentication "Basic"and worked.
Thank you!