Forum Discussion

MegV's avatar
MegV
New Member
1 year ago

Save pbx file without data

Hello I have a dataset with sensitve Data in import mode. Currently I can't switch to direct query or direct lake.  I do not have a data protection compliant storage location for the pbx file. Ther...
Need Help
rohit1991's avatar
rohit1991
Super User
1 year ago

To address your concern about sensitive data in your PBIX file, here are some solutions:

  1. Save PBIX Without Data: In Power BI Desktop, go to File > Options and Settings > Options > Current File > Data Load and select Clear cache. Then, go to File > Save As and save the file. This removes the loaded data but keeps the model and queries.

  2. Force Update on Open: In Power BI Desktop, use Parameters to ensure the queries require user input or credentials on file open, preventing data from being loaded without authorization.

  3. Use a Script or Tool:  Consider using Power BI REST API or PowerShell scripts to automate removing data from the PBIX file before saving.

  4. Restrict File Access: If avoiding sensitive data isn't fully possible, encrypt the PBIX file with a secure tool before storage to prevent unauthorized access.

These steps should help secure your PBIX file while maintaining usability. Let me know if you need further guidance!