Forum Discussion
Large database: customize import?
hi, Simon_Striegel
Yes, you could get it in Edit Queries, please refer to this similar post:
https://community.powerbi.com/t5/Desktop/Filter-query-by-date-column/td-p/333186
Best Regards,
Lin
Thank you for your suggestion. Unfortunately, correctly filtering data based on current time is not really the problem with which I'm grappling.
Perhaps a more lucid description of my problem is needed.
The data I wish to analyse using PowerBI is in a SQL database and includes some *very large* tables -- several 100 million rows and tens of GB -- with timestamp as the primary key. These data are generated by the application and there already are processes in place to discard "aged" data from these tables.
The PowerBI analysis will *always* have a time bracket on the data, ranging from the past hours to the past days/weeks -- i.e., over a much smaller subset of the table that the SQL database can easily/quickly provide via primary key.
When I "Get Data" in PowerBI, I would like to limit the amount of data loaded to, say, the past 12 hours (and not all the several 100 million rows). I would appreciate any suggestions on how best to do achieve this.
Kind regards,