Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

power BI desktop | partial data pull using mysql db Import

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
5 years ago
Apparently issue was with Data source/DB itself - Hence closing this task
thanks all for your response 🙂

HashamNiaz
Solution Sage
5 years ago
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
  Not applicable
  5 years ago
  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.
Anonymous
Not applicable
5 years ago
Apparently issue was with Data source/DB itself - Hence closing this task
thanks all for your response 🙂