Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
PowerBI4Life
Frequent Visitor

Python in Power Query Editor

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? 

1 ACCEPTED SOLUTION
ams1
Super User
Super User

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.

View solution in original post

1 REPLY 1
ams1
Super User
Super User

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors