Automate exporting data from data view using Python

[Ron19]

Hi All,

I have extracted data from my server and added some columns in Data View. How do I export these to csv file using Python automatically?

I have found some thread using Python script in Transform data, but in transform data all my added columns will be lost and it doesnt support DAX.

Any help will be greatly appreciated. Thank you.

[lbendlin]

Run a DAX query against the dataset via ADO

Using Python to Execute DAX Queries in Power BI & SSAS Tabular - Part 1 (antmanbi.com)

[Ron19]

Thank you very much for your solution but it is too complex for me. I'll try to use power automate to do this.

[lbendlin · Accepted solution]

Great choice. Make sure to read about the limitations. Include Nulls.