Forum Discussion
Your file has been disconnected and data source credentials greyed out
Hi PBION ,
Thank you for reaching out to Microsoft fabric community forum.
The error message "We are unable to access some data source because the artifact is missing connection details" indicates that the Power BI Service dataset has lost its connection to the original data source. This can happen if SharePoint permissions or data connection ownership change, or if the dataset is republished from Power BI Desktop with updated metadata, causing it to be recognized as a new artifact.
Since your SharePoint list access was recently reduced and you no longer have full edit rights, this is likely causing the issue. Power BI requires at least read and schema-level access to validate and refresh the connection; lower permissions can prevent the dataset from accessing connection details, leading to greyed-out credentials and refresh errors.
To resolve this, check your SharePoint permissions and request temporary Edit or Full Control access if necessary. Power BI needs metadata-level access even if only read access is needed for visuals. Once permissions are restored, go to the dataset in Power BI Service, select Settings > Data source credentials, and re-enter your organizational account to rebind the connection. Also, confirm that both SharePoint List and Access Database sources are mapped to the same gateway cluster under Manage Gateways.
Hope this helps. Please reach out for further assistance.
Thank you.
This is a known issue that usually happens when PBI Service cannot identify your data source path or authentication method after a recent update.
Here is what you can try to fix:
Check SharePoint connection type:
In desktop, make sure you are using the sharePoint online list connector, not the web connector.
Reconnect using the full site URL (for ex: https://yourtenant.sharepoint.com/sites/yoursite).
Access Database path:
Ensure the access file path in desktop matches the one configured in the gateway.
The Access Database must be on a local/network drive accessible by the gateway machine.
Gateway mapping:
Go to manage gateways in PBI Service.
Verify both data sources (SharePoint + Access) appear under the same gateway cluster and are mapped correctly.
Republish clean:
Delete the dataset from Service.
In Desktop, clear all credentials (File -> Options > Data Load > Clear Permissions).
Re-publish the report, then reconfigure credentials in Service.
If the issue persists, it is likely due to Microsoft’s recent security update affecting access database connections via gateway (especially with Office updates).
Simple workaround: move the access data to SQL Server or an excel file on SharePoint/OneDrive.
Hello,
1. Check SharePoint connection type: Confirmed it is SharePoint connector not web
2. Access Database path: Confirmed (other reports are accessing the same database and refreshing without issue using the same path)
3. Gateway mapping; Confirmed (I only have one gateway, both are mapped to this gateway)
4. Republish clean: Deleted both in service and readded, as well as cleared permissions.
The issue still persists. Unfortunately we cannot move out of the Access db yet.