Forum Discussion

jimmydave's avatar
jimmydave
Regular Visitor
10 months ago
Solved

“Artifact is missing connection details” (Google BigQuery connector suddenly unbound)

Hi all,   I’m running into a recurring issue with semantic models (3 models in total) that all use a shared BigQuery connector in Power BI Service. These models have been refreshing daily on schedu...
Need Help
  • tayloramy's avatar
    tayloramy
    10 months ago

    Hi jimmydave, you can use the admin APIs GetActivityEvents or search the global audit logs in Purview. 

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, please mark this as the solution. 

jimmydave's avatar
jimmydave
Regular Visitor
10 months ago

Thanks tayloramy for your reply.

 

1. Each connection is a Cloud connection.

2. Already done. I am the only user and owner of the connection.

3. Connection is the same BigQuery Connector (BigQuery via JSON).
4. I have created an additional connection to see if this has any impact.

 

As mentioned this has been happening randomly, so will continue to monitor.

  • tayloramy's avatar
    tayloramy
    Icon for Super User rankSuper User
    10 months ago

    Hi jimmydave, 

     

    Intermittent issues are always the worst to troubleshoot. 

    Are you using deployment pipelines or version control that could be unintentioanlly changing the connection? You mentioned this just started, so likely not, bit figured I'd ask. 

     

    Do you happen to have an on prem data gateway at all? This is a cloud connection so a gateway should not be required, however I have had luck in binding cloud connections to a gateway to correct some odd behaviour in the past. 

     

    The error This semantic model was disconnected from data sources when it was edited by a user who wasn’t authorized to use the data connections usually means that someone touched something, I've never seen it mean anything else in my enviornment, Is there a chance that someone was looking at the semantic model in the web view and flipped to edit mode, didn't change anything, and flipped back to view mode? I think the service might see this as a change if that user did not ahve permissions on the connection. 

     

    Are you at all able to make a temporary workspace that only you have access to and see if you can re-create this issue? If you can re-create it in a workspace that only you have access to, then this is very likely a product bug that should be reported, but I'm not quite sure if we're ready to scream bug and pretend we've solved this yet. 

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

     

    • jimmydave's avatar
      jimmydave
      Regular Visitor
      10 months ago

      Hi tayloramy ,
      Thanks agian for the detail. I've been monioring for the past week and it happened again today (randomly) to 1 out of my 3 models.

      In terrms of the somebody touching something - I am the owner of the workspace and only minimal users have access to the workspace directly (however the APP has many users). 

      I will create an additional workspace and see if I can re-create the issue. 

       

      Thanks again for your support.

       

      • tayloramy's avatar
        tayloramy
        Icon for Super User rankSuper User
        10 months ago

        Let us know if you're able to recreate it. 

         

        I have a feeling this is a user training issue and someone is touching something, but if you can replicate it in a workspace that no one else has access to then that throws that idea out the window.