MySQL query returns less rows where as same query loads more rows in Power BI

Question

Hi All,&nbsp;I have to load data from MySQL and my query gives around 300K records and when I use same query in Power BI to get the data it tries to load complete table which is very huge close to 1 million and there in Power BI stops working.&nbsp;Please suggest possible solutions.&nbsp;CheersShelly

arul · Answer

shelly_sethi&nbsp;,Did you used the advanced options to write your query to import the data?&nbsp;Thanks,Arul

shelly_sethi · Answer

Yes Arul,I used advanced option.

arul · Answer

shelly_sethi&nbsp;,If possible could you share some sample query and the output of what you are receiving?&nbsp;Thanks,Arul

arul · Answer

shelly_sethi&nbsp;,Also check the server and table details for the same in Power BI.&nbsp;Thanks,Arul

shelly_sethi · Answer

Arul Server and table are correct.&nbsp;Same query working fine on other pro license and other system.&nbsp;Sample query like&nbsp;Select * from XYZ where A is not null and B is not null---it generates around 300K records in MySQLwhere as same query keeps on extracting whole table and Power BI gets stuck.Hope this helps in understanding the issue.&nbsp;ThanksShelly

Forum Discussion

MySQL query returns less rows where as same query loads more rows in Power BI

5 Replies

Related content

MySQL Connector - Direct Query

Direct Query mySQL

Direct Query MySQL

Ghost queries from MySQL

MySQL Direct Query