Forum Discussion

MarieD's avatar
MarieD
Helper I
6 years ago
Solved

Limited load from data souce

Hi all,   I'm new to PowerBI and want to make reports from a Magento Database. the connection has already been set up by using Mysql connection, but the problem is that there are a lot of rows in t...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    You could do it with an SQL statement but it is easier to use Keep Rows in the query editor.  In your query, click on your 2nd step or on the Filtered Rows step, and on the Home tab click on KeepRows/Keep Top Rows.  Put in 1000 in the popup and it should add a Keep Rows step.  That way, query folding should still occur.

     

    When you are done with your query building, you can just remove that step to get all the data when you need that.

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, MarieD 

 

I'd like to suggest you use 'Filter rows' feature to filter out the data youwant. Or you can do the filter when you connect to the database. I created data to reproduce your scenario.

Testalq:

 

 

You may use filter rows to filter out the result as below.

 

Then you can right-click the step 'Filter Rows', click 'View native query', copy the codes.

 

Then you can create a new query, click 'Advanced options', paste the codes in 'SQL statement'.

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • MarieD's avatar
    MarieD
    Helper I
    6 years ago

    Many thanks for your help!!