how to use POWER QUERY values in dataframe

[volyn]

Hello,

I have built Python visual in POWER BI desktop and I tested it on fictive data generated directly in script via DataFrame

df = pd.DataFrame({

'group': ['A'],

'var1': [38],

'var2': [29],

'var3': [17],

'var4': [27],

'var5': [28]

})

If I want to use values from my query which was created in POWER QUERY, how can I  use it to feed DataFrame in Python pls?

Thanks

O.

[v-chenwuz-msft · Accepted solution]

Hi @volyn 

I found this article to see if it helps you. You need creat a table from power query and close&apply. Then the table will show under the Fields. And drag it to the python visual’s Values directly.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals

and this the video.

Best Regards

Community Support Team _ chenwu zhu

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