We are developing reports off of a not so well designed data model. We have 85million rows in the database. Currently users are able to visualize the data through Spot Fire visualizations because Spot Fire (Tibco) allows on-demand/dynamic querying. We are now building the same visualizations in Power BI.
If we use Data Import, it is too large of size and even if we use direct query, we will not be able to pass parameters on the fly. For example, the users are looking at 13 months of historical data. If there is a way to query the data for each selected day, reports will work fine. But Power BI doesn’t allow this on-demand data load.
If someone can point me to a content in this forum or Sam’s tutorials or suggest a work around, it is a great help.