HOW TO GET PART OF THE DATA OUT OF DB2 DATABASE?

[christianfcbmx]

Question dear Community! pretty new working with powerBI this is my first shot and I need to know something before...my problem is that I have a big data base which is constantly growing (DB2) and I d like to prcess some data for example in this particular case all columns but only the newest 100k rows, otherwise to download to BI desktop and refresh 10.000k data rows would take forever and I need this refresh every 30 minutes to see some data behaviour ....anyone could share a link where I could learn how to get the newest 100k rows only outta this database???? THANKS in advance for any help I could recieved!!!!!!

Note:I dont know what kind of parameter I need to use either....in this case data doesnt have dates they are only numbers (if Id like to get data by dates), so I dont know how to get always the last 100k rows

[v-sihou-msft · Accepted solution]

@christianfcbmx

Since you have a big dataset, I suggest you use DirectQuery mode. It refreshes data about every 20 minutes internally.

For taking the last 100K rows, you can add a TOPN filter on date column.

Regards,

[christianfcbmx]

Im still trying to do it, but I think you are right...Ill try to use directquery and add a filter after that...Ill tell tou how it goes later Simon,,,,thanks!