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! 🚀
