How to split rows by 5000 records?

This might be more manual than you want, but you could do this:

1) Set an INDEX number for the original table (it's in Query Editor under Add Coluimn)

2) Under Modeling, select New Table and create 20 calculated tables like so:

Table1 = CALCULATETABLE(
               OrigTable,
               OrigTab[Index] >=1 && OrigTab[Index] <= 5000
)

Table2 = CALCULATETABLE(
               OrigTable,
               OrigTab[Index] >=5001 && OrigTab[Index] <= 10000
)

etc

Hope this helps

David

Update:

I found the easier way to do it. Maybe it will help someone else.

1. Create an Index column
2. Add the Index as a filter on the report view
3. Click 'New Group' in the fields menu
4. Set the required bin size. That is!

That is why I love PowerBi :)