Dataset not syncing after CSV file was deleted

[davisj]

I have a dataset for a CSV file in OneDrive and there are a few reports powered by this. I deleted the file accidentally but had it restored shortly after. However, the dataset is not refereshing anymore and it says the file can't be found. How can I restore the connection without having to redo my reports? 

I am on PowerBI Web.

[v-yuezhe-msft · Accepted solution]

@davisj,

Do you directly connect to the CSV file in Power BI Service and create the report? If so, please re-connect to the CSV file in Power BI Service, then create a empty report and move visuals from original report to this newly created report. For more details, please review the following blog:

https://powerbi.tips/2018/01/move-visuals-between-reports/

Regards,
Lydia

[davisj]

Thanks Lydia, that worked. I was trying to copy/paste across tabs which is why it wasn't working.

Having said that, it would still be useful to have a feature that let's you restore these connections. I have had to redo multiple reports in the past due to the same issue.

[davisj]

I have a dataset for a CSV file in OneDrive and there are a few reports powered by this. I deleted the file accidentally but had it restored after sometime. However, the dataset is not refereshing anymore and it says the file can't be found. How could I restore the connection without having to redo my reports? 

I am on PowerBI Web.