Your file was published, but disconnected

[aAmirkHan]

Hi,

I have created mixed connections through Direct Query from SQL Server Analysis and others from Excel Import Mode. When I published this report into Power BI Service then I got this error "Your file was published, but disconnected",

When I check it in Power BI Service where it shows that my Gateway connection is working fine but not sure why it is showing an error that "One or more cloud data sources for this semantic model have been deleted"

Can you please advise how to fix this error?

  

 

[Anonymous]

Hi @aAmirkHan , hello lbendlin, thank you for your prompt reply!

For your issue, please click "Recreate cloud data sources" and reenter credentials in the “Data Source Credentials” section for your data sources.

If the issue persists, go to the Manage Gateways page, check and make sure the dataset is connected to a gateway and every data source that requires a gateway is mapped.

More information for your reference:

Power BI – How to Fix: One or more cloud data sources for this dataset have been deleted – Recreate ... 

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

This is not an error. It is merely a notice that you need to do additional work if you want to have this refreshed on a schedule.

Make sure all data source credentials in the service are updated and the gateway is mapped if required.

[aAmirkHan]

Hi @lbendlin 

Thanks for the response. Can you please advise how to take all the necessary steps to remove such notice as error?

Please share any videos and documents so that I can execute them.

[lbendlin]

Make sure all data source credentials in the service are updated and the gateway is mapped if required.

Go to the settings page for the semantic model by clicking on the green "Open dataset settings"  button.  Make the changes.