Forum Discussion
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...
Anonymous , You can copy a table to excel from Data view.
refer : https://youtu.be/1_XlyzV-PcY - last option in video
Anonymous , 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?