Convert tables in pbix file to MySQL create statement

[lucasbassoli26]

Hi, 

I was given a pbix file to create a report, and I'd like to do some data exploration first to get familiar with it before creating the report. Maybe even see how the data needs to be cleaned up. I'm much quicker and familiar with SQL, and would rather do this exploration in that. Is there a way to export the pbix files tables (or a subset of them) to a MySQL database, either through a python script in PowerBI Desktop, or a quick manual *ugh* workaround? Thanks!

[Pragati11]

HI @lucasbassoli26 ,

You can't directly convert your data from Power BI to SQL create statement.

You can go with the option that @amitchandak has suggested.

Thanks,

Pragati

[amitchandak · Accepted solution]

@lucasbassoli26 , You can copy a table to excel from Data view.

refer : https://youtu.be/1_XlyzV-PcY - last option in video

[lucasbassoli26]

Hey @amitchandak, yes I'm familiar with copying the table. But then I'd need to write an entire pythonscript to loop through that excel file, and insert into the database in batches because the rowcount is high. Is there a more direct way to do this?