Data privacy with DAX Studio and PBI Data Cleaner

[Imrans123]

Hi All, 

Hope you guys are doing good. I had a quick question. I would like to use the Power BI Cleaner app by Biccountant i.e. https://www.thebiccountant.com/2021/06/27/power-bi-cleaner-gen2-is-here/ to help me filter out any unused columns or measures from my model

However, I would need to pass my data through DAX Studio and then the PBI Template file in order to do so. I was wondering whether there is any way my data can be comprimised or pass through any external party if I use either of these applications?

[AlexisOlson · Accepted solution]

DAX Studio sends your code through DaxFormatter.com when you ask it to format it, so that's theoretically a potential security issue if you have anything sensitive in your DAX itself.

There are privacy settings you can use to disable any internet access:
https://daxstudio.org/documentation/features/privacy-settings/

It may also be worth noting that the code is open source:
https://github.com/DaxStudio/DaxStudio

And it's apparently "Approved w/Constraints" for the US government:
https://www.oit.va.gov/Services/TRM/ToolPage.aspx?tid=14259&tab=2#