Forum Discussion
Solved
Filter
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 availa...
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.
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)?