Forum Discussion

davisj's avatar
davisj
New Member
7 years ago
Solved

Dataset not syncing after CSV file was deleted

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.

 

  • Anonymous's avatar
    Anonymous
    7 years ago

    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

3 Replies

  • 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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      davisj
      New Member
      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.