I have two projects with two Bigqueries, but Power BI is mixing them.

[EmanuelTavares]

Hi,

I have been developing a project using Bigquery as the data source. This project has a Power BI and a Bigquery accounts.

Now I'm starting a new project using Bigquery as the data source. This project has another pair of Power BI and Bigquery accounts, but Power BI is mixing them.

I read there was a limitation on Power BI services working with two different Bigquery connections, but this is not the case. I have two separate files, accounts, etc., and the post was from 2022!

The only solution I found is manually changing the connection depending on the project I'm working on, which is really annoying. 

I have never seen anything like this. I have a lot of projects with AWS connections and it never happened. I believe that it could be related to the authentication method that uses the browser, but does it make sense?

Is that it? Is it a product limitation?

I wonder what will happen if I take a third project using BigQuery.

Any suggestion?

[lbendlin]

Yes, it's a design limitation in the way Power Query caches credentials. It is unable to understand that you are addressing different endpoints, likely because they resolve to the exact same URL.  See if you can change the URL to make it unique across the sources.

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[EmanuelTavares]

I didn't understand your answer.

I have two projects, two clients, and two different Bigqueries.

I didn't have the parameter "Endpoint" in a Bigquery connection configuration. That is the problem.