Forum Discussion
christianfcbmx
Post Patron
Post PatronHOW TO GET PART OF THE DATA OUT OF DB2 DATABASE?
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 ...
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,
v-sihou-msft
Microsoft Employee
Microsoft Employee
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,
christianfcbmxPost Patron
Post PatronIm 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!