Forum Discussion

bdl5119's avatar
bdl5119
Advocate I
5 years ago

Import python script into powerBI and publish dashboard

Hello,

I am sourcing the python script file1.py in my dashboard for a visualization. However, since the file is stored locally in my C: drive, I cannot use the published dashboard. How can I store file1.py on my workspace online and execute it?

 

Code in power bi is:

exec(open("C:\\file1.py").read())

 

2 Replies

  • "However, since the file is stored locally in my C: drive, I cannot use the published dashboard"

     

    Not sure what you mean by that - can you please elaborate?

     

    Python and R scripts in a workspace require the use of a personal gateway.  Have you set that up?

    • bdl5119's avatar
      bdl5119
      Advocate I

      Yes, but that is not feasible solution as others cannot generate the visualization if my lapop is switched off. The solution is for me to publish my code to PyPI then import it as a package.