I have two tables in my Power BI (both made from append queries) and I need to compare them to create my report. I have a script in Python that works in the coding environment but, when trying to use it in Power BI, I have been unable to reference the tables in my scrip. I keep getting the same error that does not recognise them. I tried following the guidance in this post and it did not work.
Power BI: How to use Python with multiple tables in the Power Query Editor?
I have been unable to find any other example of how to do it. Do you have any guidance?
Thanks in advance.