Python Integration

[alongi]

Hi, we are working on a report that has pretty involved DAX queries potentially. We would like to be able to leverage Python(if possible) rather than use complex DAX. We have never used Python within Power BI previously. Is it possible to leverage Python such that if we need to filter a report by year, Python can dynamically perform some processing based on the user selection and put the end resultant data into a table.

Thanks

[amitchandak · Accepted solution]

@alongi , You can replace complex columns, not measures using Python.

Share what is measure you think are complex. Maybe someone here can help you with optimized measures.

refer if needed

PowerBI Abstract Thesis: How to make Python work with Power BI: https://youtu.be/5D0BkNsu5CM

[alongi]

Appreciate the feedback, we actually figured out the DAX solution