I have written a program to carry out a complex calculation with multiple python scripts that queries multiple database tables. Is it possible to run the main() python script that imports the other python files from Power bi?
1 Answers
Of cause you can run multiple Python scripts in Power BI to import data into the data model, but there are some considerations:
- each Python scripts has to result in a separate table
- only pandas data frames are imported
- any script running longer than 30 minutes times out
- there are limitations wrt 3rd party packages when running on the Power BI service.
You don't need a "main" script to control the others. They are all executed on a Power BI data refresh request.
For more information read this:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts
Related