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

[shelly_sethi]

Hi All,

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.

Please suggest possible solutions.

Cheers

Shelly

[Arul]

@shelly_sethi ,

Did you used the advanced options to write your query to import the data?

Thanks,

Arul

[shelly_sethi]

Yes Arul,I used advanced option.

[Arul]

@shelly_sethi ,

Also check the server and table details for the same in Power BI.

Thanks,

Arul

[Arul]

@shelly_sethi ,

If possible could you share some sample query and the output of what you are receiving?

Thanks,

Arul

[shelly_sethi]

Arul Server and table are correct.

Same query working fine on other pro license and other system.

Sample query like

Select * from XYZ where A is not null and B is not null---it generates around 300K records in MySQL

where as same query keeps on extracting whole table and Power BI gets stuck.

Hope this helps in understanding the issue.

Thanks

Shelly