Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
C_lad
New Member

Connected BigQuery to PowerBI with Service account using BigQuery connector, sometimes working

Hi all,

 

so I connected PowerBI Desktop and BigQuery using the BigQuery connector, using a service account, this worked all fine, but today somehow it cannot connect anymore. I always get the error:
"We couldn't authenticate with the credentials provided. Please try again."

 

Then some hours later it starts to work again with the exact same approach, pasting the the service account email into mail and the contents of the json key file into the other field...
Did anyone encounter similar or the same behaviour? 

If so could you manage to somehow resolve it, that this does not happen again?

Does someone know why this is happening and if / where I could raise this issue?

Best regards.

2 REPLIES 2
C_lad
New Member

@amitchandak thanks for the reply, I already tried to clear the credentials while it was not working and even entering the correct credentials led to the same error... 
Then after some time it just started to work again without changing anything, which is really strange...

amitchandak
Super User
Super User

@C_lad , I doubt

One is the query/data limit for the credential used

The second is ip access issue.

 

You can try clear permissions (Home -> Transform Data -> Date Source Setting), Provide credential  again and try 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.