Forum Discussion
Filter
If the data is your data warehouse is streaming type data, which is requiring the direct query you can look into updating the model to a star schema and having the dim tables in import mode.
I use DirectQuery to connect to live data. The main goal is to ensure that the data is up-to-date with each query. However, i am only using one table for the report and do not use a star schema. I am using a custom visual to filter the table column: Smart Filter Pro - OKVIZ
To be fair, I did not create the report; I was just given the task to make it faster. The idea of getting different tables and connecting them all while we request a query could be the best option available.
If the data is your data warehouse is streaming type data, which is requiring the direct query you can look into updating the model to a star schema and having the dim tables in import mode.
this helped alot, thanks.