Forum Discussion

Pover's avatar
Pover
Frequent Visitor
2 years ago

Shareable cloud connections for datasets

Has anyone had success using shareable cloud connections to connect to GBQ? I can change my personal cloud connection to a different one that uses a service account. However, when I refresh the Dataset, I get the "The key didn't match any rows in the table" error that indicates that the connection cannot see the table even though the service account has access to the table in GBQ.

Need Help

2 Replies

  • Pover's avatar
    Pover
    Frequent Visitor
    2 years ago

    Thanks for replying Gilbert.

    Upon further testing, the shareable cloud connection functionality works with GBQ. The issue appears to be getting the GBQ cloud connection to see the projects that the Service Account has access to.  Everything is working fine with Organizational Accounts. 

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi Pover 

     

    When you create the Shareable cloud connection in the Gateway settings in the Power BI Service, can you see that it connected successfully.