Forum Discussion
Accessing Filters (particularly date filters) to improve PowerBI Custom Connector performance
Super UserFascinating. I think philosophically the issue is that Microsoft were not thinking the way you are thinking when they designed the original version of Power BI as a strict one way street (in terms of data flow). Now they are scrambling to accommodate the new customer requirements for timeseries based reporting as well as data source write-back.
Really looking forward to what you find out. Best of luck. ImkeF - fyi
But controlling your date range is so fundamental to reporting, I've got no idea how the system could have been designed without this in mind.
While not ALL reports reflect date ranges (many dashboards only show the latest values), the point of the majority of all reporting is to summarise the activities across a date range. The idea that you should query all of recorded history for a report that only covers the last 24 hours is...not very clever.
I know I'm worst-case-scenario for this sort of thing (1-second resolution data over several years of recording), but surely this limitation is causing headaches for a large number of users, particularly if you're only limited to 16MB of data from a Gateway connector.