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.
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/transform the data from both the above mentioned data source into Power BI desktop app for report generation.
Quesiton:
How to do this?
I am no Python expert but can't this be done in Power Query instead?
Proud to be a Super User!
Hi All.... is there any way to address this problem.... please let me know....
Hi All.... is there any way to address this problem.... please let me know....
Sure @amitchandak , will create a scenario and share at the earliest
Proud to be a Super User!
@rajaranjith , Each python script is added as a source, I doubt it work line a db/file connection
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.
@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,
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.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |