Forum Discussion

thmonte's avatar
thmonte
Helper IV
6 years ago

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...
Need Help
  • thmonte's avatar
    thmonte
    Helper IV
    6 years ago

    Anonymous I've read these documentations.  I had follow up questions which is why I made this post.

     

     

    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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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

       
      • GilbertQ's avatar
        GilbertQ
        Super User
        6 years ago
        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.