Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
@lucasbassoli26 , You can copy a table to excel from Data view.
refer : https://youtu.be/1_XlyzV-PcY - last option in video
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
@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?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |