Forum Discussion
Performance Issues with ODBC
We keep most of our data within MongoDB and have setup BI Connector mySQL to access this data in other reporting programs. We havent ever ran into any issues using BI Connector until we've started m...
Hi GilbertQ ,
Could you please help answer these problems from thmonte ? Thanks a lot for your help and time in advance.
How can I make this expereince better? Is there any benfit to using the native MySQL source rather than ODBC? Can I make changes to the Power Query for the ODBC? I noticed there was a Row Reduction Clause option in the Power Query but will this limt the data across the reports (meaning will only 1000 rows ever be available to report on) or just for loading into Power Query?
Best Regards
Rena
Hi there
Using the Navtive MySQL source will allow for potential query folding, which means you could then use incremental refreshing too.
With regards to the Query Reduction, my understanding is that this will limit the amount of rows returned when using Power Query. But once the dataset loads it will load all the data.
Using the Navtive MySQL source will allow for potential query folding, which means you could then use incremental refreshing too.
With regards to the Query Reduction, my understanding is that this will limit the amount of rows returned when using Power Query. But once the dataset loads it will load all the data.