Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lucasbassoli26
Frequent Visitor

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!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

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

View solution in original post

3 REPLIES 3
Pragati11
Super User
Super User

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

amitchandak
Super User
Super User

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

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

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?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.