Forum Discussion

G_CR_23's avatar
G_CR_23
Icon for Helper I rankHelper I
3 years ago

Connection Error: Your file was published but disconnected

Hi all, i'm facing some issues with a composite model (1 pbi dataset, 1 googlesheet and 1 table from a sql server). When i publish there is an error message "Your file was published but disconnec...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
mohitkumawat's avatar
mohitkumawat
Icon for Impactful Individual rankImpactful Individual
2 years ago

here's a more concise breakdown of the steps to address the issue with your Power BI report:

  1. Check and ensure correct data source connections, including credentials.

  2. Verify and update the on-premises data gateway settings for the SQL Server.

  3. Validate and update the connection to the Google Sheets source.

  4. Confirm cloud data sources in the dataset settings and ensure they are correctly connected.

  5. Ensure the on-premises data gateway is running and accessible; consider restarting it.

  6. Attempt to publish the report again after addressing any issues with connections and settings.

  7. Check workspace settings for any restrictions or configurations causing the issue.

  8. If the problem persists, create a new workspace and attempt to publish the report there to isolate the issue.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    What if the source is only an excel file on Sharepoint.?

    I receive an error while publishing that the file was published but disconnected.

    To correct this.. I created a gateway on my laptop and assigned it to the report. However, the gateway doesnot seem to work as the data is not refreshed on the dashboard when I refresh my source excel file.