Forum Discussion

Jeanxyz's avatar
Jeanxyz
Icon for Power Participant rankPower Participant
2 years ago
Solved

get data via python script

I'm learning to import data via python script following Microsoft tutorial (https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts). I have installed python, pandas, matplotli...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    works fine for me.  Re-do your Python setup on that PC.

    No need to print the variable.

     

     

    let
    Source = Python.Execute("import pandas as pd#(lf)data = [['Alex',10],['Bob',12],['Clarke',13]]#(lf)df = pd.DataFrame(data,columns=['Name','Age'])"),
    df1 = Source{[Name="df"]}[Value]
in
    df1

     

     

     

id013's avatar
id013
Icon for Helper V rankHelper V
1 year ago

So I am also creating a data model via python, and it works fine on my desktop. However while I can deploy the model to service I don't see a way that I can have PBI Service refresh the model for me. Is this just a limitation of PBI service and the on-prem gateway or am I missing something. 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

a service refresh MANDATES the use of a PERSONAL gateway.