Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Convert tables in pbix file to MySQL create statement

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!

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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?

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    HI Anonymous ,

     

    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