Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Are there any risks to using Python in the Power Query Editor? It sounds like the data source settings must be set to "public". Who would be able to see this information?
Solved! Go to Solution.
Hi @PowerBI4Life ,
Everything has risks 🙂, IMO the biggest one being the user doing something wrong in the code that exposes the data.
"python.exe" installed on your machine will be able to "see" your data.
The thing is python.exe is an external program installed on your machine and PowerBI gives python your data - so if your machine is compromised... things might happen (btw if your machine gets compromised not even PowerBI is safe anymore).
Python also has libs (pandas etc.) - if those libs get compromised...
IF you're careful and install python/python libs from trusted locations (btw same goes for PowerBI itself and everything), you should be OK -> (imo) this "worrying" should NOT stop you for using python, go for it!
Worry more about the code you use in PowerQuery, Python etc.
Hi @PowerBI4Life ,
Everything has risks 🙂, IMO the biggest one being the user doing something wrong in the code that exposes the data.
"python.exe" installed on your machine will be able to "see" your data.
The thing is python.exe is an external program installed on your machine and PowerBI gives python your data - so if your machine is compromised... things might happen (btw if your machine gets compromised not even PowerBI is safe anymore).
Python also has libs (pandas etc.) - if those libs get compromised...
IF you're careful and install python/python libs from trusted locations (btw same goes for PowerBI itself and everything), you should be OK -> (imo) this "worrying" should NOT stop you for using python, go for it!
Worry more about the code you use in PowerQuery, Python etc.