Filter

[plsHelpMe]

Hello,

I currently have the problem that I want to filter a table by a serial number and then get all the matching values. However, the table I have connected via Direct Query first loads all available values. This takes a few minutes, and if you could pass the serial number before it loads everything, you would save time.

I have found several approaches for this, but they do not seem to work. If anyone has an idea, please let me know here briefly, as this is currently unbearable with the report.

The Helpseeker...

[plsHelpMe]

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.

[audreygerred · Accepted solution]

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. 

[plsHelpMe]

this helped alot, thanks.

[audreygerred]

Hello! May I ask, what is your use case for direct query rather than import? Do you have your model set up as a star schema (i.e. do you have a dimension table that has the unique serial numbers which will then filter the fact table)?