Forum Discussion
Solved
The pandas code read_excel() does not work in Python/Excel, unlike in native Python.
I have an issue when I try to read a specific workbook in Excel using pandas read_excel() The following code was tested natively and it worked: import pandas as pd pth = "C:/Users/XXXX/Python 1...
That's data security, more details in related post.
I don't think that's a big issue. You may Power Query external file (or any other source) and do nothing with it, just save as connection only. Next on Python
df=xl("MyConnectionName")
and do all transformations with Python.
Thanks for your reply. It is unfortunate. Do you know the reason why ?
Python is easier (more flexible) than Power Query for ETL (from my point of view).