Forum Discussion

rowsandcolumns's avatar
rowsandcolumns
New Member
7 years ago
Solved

Delete imported data (required by GDPR)

GDPR requires that Personal Data be deleted within 30 days of such request by the data owner.   If I "Import" data instead of "Direct Query", how can delete the imported data, or ensure that it is ...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi rowsandcolumns,

     

    Yes, your understanding is right. In addtion, if the path of your data source has been changed, you can't refresh your dataset even if you are using import.

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Hi rowsandcolumns,

 

You can use a sql statement to import data with past 30 days to solve this.

 

Regards,

Jimmy Tao

rowsandcolumns's avatar
rowsandcolumns
New Member
7 years ago

Thanks for the response.  I may not have explained the need clearly.

 

My understanding is that when I do an "Import" that Power BI Desktop puts the data somewhere in the cloud.  

==> Is that correct?

 

If so, how do I clear it out of the cloud? 

 

If not, then it's not a problem after all.

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi rowsandcolumns,

     

    In power bi desktop, "import" will only import the data into your PBIX file(after saved). If you publish your PBIX file to power bi service and configure a schedule refresh once a month, the old dataset will be replaced by the new dataset. So you don't need to delete the old data manually.

     

    Regards,

    Jimmy Tao

    • rowsandcolumns's avatar
      rowsandcolumns
      New Member
      7 years ago

      Thanks for the response.

      My confusion was that "import" and "(cloud) service" were interconnected.

      I won't be using the cloud service so I can remove that from consideration, and only think about local files.

      My new understanding is that Power BI Desktop Import is like MS Access importing of Excel data vs linking to Excel.

      If the import PBIX  is saved, it can be managed as a local file.

      If the import PBIX is not saved, there is not even a local file to deal with.

      Is that all correct?

      • v-yuta-msft's avatar
        v-yuta-msft
        Community Support
        7 years ago

        Hi rowsandcolumns,

         

        Yes, your understanding is right. In addtion, if the path of your data source has been changed, you can't refresh your dataset even if you are using import.

         

        Regards,

        Jimmy Tao