Forum Discussion
Solved
Update MySQL dataset with only additional rows (not reload the entire thing)
This is on Power BI desktop... I have 40 million rows (and counting) in a MySQL database and one column is a JSON package which has to be parsed. This isn't an issue, but it does take a while to ...
There are some suggestions for you.
a. Write specific SQL query to import required columns and rows from MySQL database to Power BI Desktop.
b. During the import process, disable the following highlighted options in Power BI Desktop.
c. Create views for different date time in MySQL database if necessary, and then import the views in Power BI Desktop.
Regards,
Lydia
There are some suggestions for you.
a. Write specific SQL query to import required columns and rows from MySQL database to Power BI Desktop.
b. During the import process, disable the following highlighted options in Power BI Desktop.
c. Create views for different date time in MySQL database if necessary, and then import the views in Power BI Desktop.
Regards,
Lydia