Edit Python query

[johnerlandsson]

I use a python query to fetch data from several text files. Whenever I need to edit the script I have to remove the query and add it again, pasting the code in the input box. If I right click my query and select "advanced editor" the script is flattened to a single row and difficult to edit.

Is there a way of opening the script in an IDLE editor?

[v-xicai]

Hi @johnerlandsson ,

You can launch your external Python IDE from Power BI Desktop and have your data automatically imported and displayed in the Python IDE.

For references:

https://docs.microsoft.com/en-us/power-bi/desktop-python-ide,

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

Best Regards,

Amy

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

[johnerlandsson]

Thanks @v-xicai!

But I think that solution is for editing python visuals. Not for editing python as a data source. Or am I missing something?

[Tshalala_95]

If the problem is actual for you, please try following steps:
1) Transform data

2) Please right click  on dataname and select advanced editor

3) Edit you source code and click Done.