power BI desktop | partial data pull using mysql db Import

[Anonymous]

Hi Team,

When I try Get data - import mysql db on powerBI, The tables that I see has some data missing,

I validated this by pulling DB tables separately on my local pc using a script and then check data on mysql workbench.

What could I be missing here?
I attempted to refresh PBI, Clear cache and then try and connect to DB again - No go.

Please advise if there is a way to properly SYNC pbi with DB - Thank you

[Anonymous · Accepted solution]

 Apparently issue was with Data source/DB itself - Hence closing this task
thanks all for your response 🙂

[HashamNiaz]

Hi !

You might be running into size limitatio. Try using Direct Query mode instead of Import Query to see if it brings all rows.

Regards,

[Anonymous]

thanks for your response,
MySQL is currently not supported for Power BI that can be used with DirectQuery, Which means I'll have to import a copy of the data into the Power BI Desktop and cannot connect directly to the data source using DirectQuery.