Forum Discussion
File was published but Disconnected
Hi Del235,
Thank you for your message. The error "File was published but disconnected" typically indicates that Power BI Service could not fully connect to one or more data sources after publishing your report. Since your report uses both Snowflake and an Excel file from OneDrive, this can occur if credentials need to be updated or if the data source connection is not properly recognized.
As lbendlin mentioned please click on the “Open data source settings” link in the message to access your dataset settings in Power BI Service. Review and update credentials for each data source under “Data source credentials.” For the Excel file, ensure you are using a web URL path (for example, from SharePoint or OneDrive online) instead of a local folder path.
If Snowflake is in DirectQuery mode or requires secure access, check the data gateway settings under “Gateway connection” and confirm the gateway is online and properly configured.
Also, verify whether the dataset is in Import or DirectQuery mode, as this will determine if scheduled refresh or live credentials are required.Thank you
Continue using Microsoft Fabric Community Forum.
Hi Del235,
Thank you for your message. The error "File was published but disconnected" typically indicates that Power BI Service could not fully connect to one or more data sources after publishing your report. Since your report uses both Snowflake and an Excel file from OneDrive, this can occur if credentials need to be updated or if the data source connection is not properly recognized.
As lbendlin mentioned please click on the “Open data source settings” link in the message to access your dataset settings in Power BI Service. Review and update credentials for each data source under “Data source credentials.” For the Excel file, ensure you are using a web URL path (for example, from SharePoint or OneDrive online) instead of a local folder path.
If Snowflake is in DirectQuery mode or requires secure access, check the data gateway settings under “Gateway connection” and confirm the gateway is online and properly configured.
Also, verify whether the dataset is in Import or DirectQuery mode, as this will determine if scheduled refresh or live credentials are required.
Thank you
Continue using Microsoft Fabric Community Forum.
Hi Del235,
We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If you need any further assistance, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!
Hi Del235,
I wanted to check in your situation regarding the issue. Have you resolved it? Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!Hi Del235,
Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.