Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |