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. 

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

Hi jimmydave,

 

Here's some steps I would take to troubleshoot this:

  1. Bind each semantic model to an explicit Cloud Connection (don’t use “Default connection”). See Connect to cloud data sources.
  2. Harden the connection’s permissions: make yourself/your SPN Owner, give others User or remove them. Same doc as above.
  3. Keep all models on the same BigQuery connector/auth type: BigQuery, BigQuery (Microsoft Entra ID).
  4. Rebind now and consider one dedicated connection per model to isolate settings. Same cloud-connections doc.

 

Also check if someone without permissions edited the artifact at all, if someone with permissions to edit the artifact but without permissions on the connection changes something, the connection will be unbound. 

 

 

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