Forum Discussion

Anonymous's avatar
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 ch...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

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

HashamNiaz's avatar
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's avatar
    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.