Service account to connect to Google BigQuery

Good Morning, Data Enthusiasts!

🔥 Need Your Expertise! Struggling with Google BigQuery Connection in Power BI Services!

Hey there, fellow data wizards!

I'm currently facing a bit of a conundrum while trying to establish a connection to Google BigQuery within Power BI Services. 🤯 Here's the deal: I've got a Google BigQuery account with a service account and its trusty JSON key. In the Power BI Desktop, I can effortlessly configure the connection by plugging in the account and that trusty JSON key. 💪🔌

BUT, and here's the kicker, when I attempt to configure the same connection in Power BI Services to enable those sweet scheduled updates, I hit a brick wall in the form of an infuriating error. 😩 It seems like Power BI Services might not be playing nice with service accounts for Google BigQuery.

🤔 So, what's the scoop? Has anyone else battled this beast? Any brilliant minds out there who can toss a lifeline or share their battle-tested wisdom? Your insights would be greatly appreciated! 🙏

Thank you so much in advance! 🚀