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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Can I call a function from a personal Python Scripit in Power BI

In Python Script in Power BI, I would like to write:

 

from personal_script.py import function

 

Is there a way of doing this?

 

Thank you

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 

I'm afraid this can't work in power bi. I have created a sample module with simple code in structure like below:

 

Func/

         __init__.py

        Func1.py

 

Code in Func.py

def func():
	print("Hello World")

Code in __init__.py

from Func.Func1 import func
In visual studio code, codes like below can work:
import sys

sys.path.append(full_path)

from Func import func

if __name__ == "__main__":
    func()
1.PNG
But in power bi python script, this can't work:
Capture.PNG 
 
I'm not sure if power bi will always ignore custom path, if you still confuse on this issue, you may submit an issue here.
 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 

I'm afraid this can't work in power bi. I have created a sample module with simple code in structure like below:

 

Func/

         __init__.py

        Func1.py

 

Code in Func.py

def func():
	print("Hello World")

Code in __init__.py

from Func.Func1 import func
In visual studio code, codes like below can work:
import sys

sys.path.append(full_path)

from Func import func

if __name__ == "__main__":
    func()
1.PNG
But in power bi python script, this can't work:
Capture.PNG 
 
I'm not sure if power bi will always ignore custom path, if you still confuse on this issue, you may submit an issue here.
 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Thank you very much for your answer 🙂 it will be nice to have this feature in the future.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.