Forum Discussion
Connection Error: Your file was published but disconnected
Hi, collinq !
Thanks a lot for the answer!
I try to explain better.
I had built a report (properly working), connected to two power bi datasets (properly configured, connected to gateway, data updated regularly, and so on).
For several reasons, I had to remove one of the two power bi datasets, and add a direct data source (basically I imported the data from one of the two power bi datasets, instead of connecting to the dataset). I specify that the imported data has the same origin as the power bi dataset (same db, same server, it's exactly them). So this data source is already configured with the gateway correctly.
Once I did this, the error "One or more cloud data sources for this dataset have been deleted" appeared in the dataset settings. I state that I removed all the data sources that are no longer needed also from the local file before publishing.
This message made it impossible for me to update the data, because it didn't allow me to select the existing gateway. It also asked me to choose a mapping for google sheets as well (which don't need gateways). I've been trying to fix it for days, with no success. So I tried to build the report from zero, assuming a bug.
I created a new pbi file, connected to a power bi data set and to the server directly (I specify that this is not the first time I have done this, there are other reports that work correctly).
When I publish the report locally on the service, I get the error "Your file was published but disconnected" with the same problems described above. Inability to update data, schedule update, select gateway. everything is blocked.
Sorry if I wrote a lot, but I tried to explain better.
Thank you!
Hi G_CR_23 ,
Have you tried to publish your newly built report with a different name to check if the issue will still happen?
- G_CR_233 years ago
Helper I
Hi mussaenda ,
yes, i tried it, but nothing happens.
If i remove the power bi dataset, all works fine (with the imported table). Gateway, update, credentials, all work fine.
Sames if i remove the imported table (so, basically a live connection to the pbi dataset).
But if i combine them together i got the messages ""One or more cloud data sources for this dataset have been deleted" and "Your file was published but disconnected" and nothing works.
It's really tricky and weird for me- collinq3 years ago
Super User
Hey G_CR_23 ,
Thanks for the long explanation! I have done a bunch of searches and talked with a couple people and don't have a much better/newer answer. One thing I ran across was to absolutely confirm that the data source settings in the pbix file is the same as the data source in the Service. I would suspect that this is not your issue but just checking.
I think that this might be time to create a ticket. Please let us know the result if you do create a ticket.
- Anonymous2 years agoNot applicable
Hi.. I face the same issue. and that too this has beena recent development.
The files in the pbix and the service are also the same. Please let me know if there is a solution to this.