Forum Discussion
"File Published but Disconnected” Error When Publishing Power BI Report
Hello, I've did exactly what you've mentioned in your post (I've wrote about it as well in my previous posts) and it did not help.
I'm not using on-prem, datasources were mapped and problem occured both on personal connector and other created specific for this issue.
I was able to resolve the issue the problem is how.
There was a Data Activator created on top of the report/app I was using. Removing Data Activator completely, get rid of this issue. Do you know why?
same thing. Had done it previously and did it again just few minutes ago and still the same message
Hi mati_gouda,
Thanks for reaching out to the Microsoft fabric community forum.
Try These -
Upgrade connectors
Switch from legacy Gen1 dataflows to Gen2 or standard cloud connectors.
Ensure you’re not blocked by permissions when doing this.
Configure/update a gateway
If your model includes on-premises or mixed-source connections, you need a standard on-premises data gateway (personal gateway won't suffice for composite/direct query models).
After publishing, go to the dataset’s workspace - Settings- Gateway connection, and map each data source to the gateway
Validate Data Source Credentials
In the service, under Data source credentials, re-enter and confirm all OAuth2 credentials (SharePoint, dataflows, etc.)
Re-publish the PBIX
After making these changes, republish. The "disconnected" banner should disappear, and the dataset will resume scheduled and on-demand refresh.
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it
Best Regards,
Sreeteja.
Community Support Team
Hello,
upgrade connectors - As you see I'm already using proper Dataflow connectors. Which are Gen2 connectors? Are there any different connectors that I'm already using?
Configure/update a gateway - it's already done. Same thing.
Validate Data Source Credentials - validated, still same issue
Re-publish the PBIX - does not help. The report is refreshing but does not want to refresh when publishing.
Hi mati_gouda ,
That “File published, but disconnected” message usually means Power BI couldn’t match the data sources in your PBIX file with the ones already set up in the service. It’s a common issue, and luckily easy to fix. After publishing, go to the workspace where your report is, open the dataset settings, and check the “Gateway and cloud connections” section. There, make sure each data source is properly mapped. For cloud sources like SharePoint or Fabric Dataflows, you might need to click “Recreate cloud data sources” if any of them look blank or broken. If you’re using on-prem data, double-check that it’s linked to the right gateway. Once everything’s mapped, hit Apply and try a manual refresh. If that works, you can set up your scheduled refresh again and the disconnected message should go away.
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find itBest Regards,
Sreeteja.
Community Support TeamHello, I've did exactly what you've mentioned in your post (I've wrote about it as well in my previous posts) and it did not help.
I'm not using on-prem, datasources were mapped and problem occured both on personal connector and other created specific for this issue.
I was able to resolve the issue the problem is how.
There was a Data Activator created on top of the report/app I was using. Removing Data Activator completely, get rid of this issue. Do you know why?