PBIX published but disconnected

Can some explain what is going on. I can publish this pbix no problem, but if one of my coleagues tries to publish it he gets a file published but disconnected.

If I go onto the service I see this. firstly there is a source ofr the analysis Service data which is a link to another modle published to the same workspace. Presuambly because it cant find this it has turned on the on premises gateway flag. The solution is turn off the on premises gateway and click in the maps to box and select the exisitng connection to trinity model and it works fine

so looks like this

So is this caused by some permissioning issue for my colleague over the Trinity model conenction I created?

the connection looks like this and we are using an admin login for the conenction and he is using the same admin login to publish (as do i) so expected it to work?

Need Help

Rupa01
2 months ago
masplin
Go to Settings in Power BI Service and Choose Manage Connections and gateways.
There you will find the cloud connection used for your dataset.
Go to more actions and choose Manage Users and check if your collegue's Id is added as a User.
Refer this link for more details - Manage Users | Microsoft Learn

💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster

Best regards,
Rupasree Achari | BI & Fabric Analytics Engineer

8 Replies

Rupa01
Solution Sage
2 months ago
Hi masplin,

When you publish a PBIX to the Power BI Service, the dataset will stay connected only if:
The data source credentials are configured properly in the Service.
The dataset is mapped to the correct gateway/cloud connection.
You have permission to use the data source in the gateway/cloud connection.
Required permissions -
Build/Edit permission on the dataset
Access to the gateway data source (granted by gateway admin) - Usually “User” access is enough to use the connection
For cloud sources - access to the connection credentials

💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster

Best regards,
Rupasree Achari | BI & Fabric Analytics Engineer
blopez11
Super User
2 months ago
Rupa01 is correct. You likely need to grant your collegue user permissions on the cloud connection.
- masplin
  Impactful Individual
  2 months ago
  but he is using the same login as me so surely has the same permissions?
  - blopez11
    Super User
    2 months ago
    The account your collegue logs into the Power BI service with is the one that needs to be granted user permissions on the connection. Go to the connection and select manage users, verify that they have user permissions.
v-anbandari
Community Support
2 months ago
Hi masplin,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to the Rupa01 ,GilbertQ ,blopez11 for sharing valuable insights.

Could you please confirm if your issue has been resolved using the suggested approach? This will help other community members facing similar scenarios.

Thank you.
GilbertQ
Super User
2 months ago
Hi masplin

Based off your responses, I do not think that the user is using the exact same account as you because if they would it should then map through correctly without any issues. So just confirm that that is the case and then make sure that you have created cloud connections for each of the data sources and the user has got permissions to use those cloud connections.
v-anbandari
Community Support
2 months ago
Hi masplin ,

Just checking in to see if your issue has been resolved. If you’re still facing any problems, please feel free to reach out and we’ll be happy to assist further.

Thank you.