Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I use Python to pre-process data before importing it to PowerBI. However, I'm having some troubles with editting the source code.
When I open "Edit Queries" and click on "Source" in the applied steps box (on the right), I am able to edit my Python source code. However, the issue is that sometimes, there is many tables. I don't want to have to edit the source code and copy and paste it for every single Data table created.
Is there a way where I can edit the source code once, and let it automatically flow through to every single data table generated from my Python script?
Thanks
Hi @Anonymous ,
We can try to define a query parameter and use it in the Python.Execute function to meet your requirement. It will change in every function after the parameter changed.
Best regards,
Hi, I'm not sure there is something exactly like you are asking, but you can consider using custom functions. If you want to reuse a code in multiple tables, you can create functions. In that way you are just changing the code in one pleace.
https://docs.microsoft.com/en-us/powerquery-m/understanding-power-query-m-functions
Regards, hope this helps.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.