Forum Discussion
rajaranjith
4 years agoFrequent Visitor
How to access multiple data source (from Excel and HANA db tables) using python script in Power BI?
Data Sources: We have 3 excel files and 2 tables from HANA Database. To Load and transform data using Python script in Power BI: We would like to have a single Python Script written to load/tra...
amitchandak
4 years agoSuper User
rajaranjith , Each python script is added as a source, I doubt it work line a db/file connection
rajaranjith
4 years agoFrequent Visitor
See I am aware of python script for each data source and to transofme the loaded data. But my request was how to have a single python script for multiple data sources to load and transorm data. As part of it I may want to join the two loaded tables to one and do some data processing.
Please let me know if I have put my question in correct form.
- amitchandak4 years agoSuper User
rajaranjith , Let's wait for the python expert to jump in. I think VijayP can help with this.
Hi Vijay, Can help with this?
Thanks,