Forum Discussion
Using a text filter and getting around Direct Query row limit
Hi, have you considered using incremental refresh on your model? This will enable you to keep your pbix file relatively empty whilst building history on your deployed model in the service.
ajohnso2 it's not something I have looked at but that might be better than trying to get it to work with Direct Query mode. As long as I am able to use incremental refresh on mulitple datasets (I have both a dimension and fact table with >1 million rows) I will try that, thanks for the tip.
Hi ali_iopp,
Thank you for reaching out to Microsoft Fabric Community.
Please follow below steps:
- Create a small table using Enter Data for user entered Asset IDs and add the AssetId data manually, do not create a relationship between this table and your main fact table.
- Now create a DAX measure in the main fact table like this below:
Filter_AssetID =
IF (
SELECTEDVALUE(FactTableName[AssetID]) IN VALUES(AssetID_Input[AssetID]),
1,
0
)
This measure checks whether the current row's Asset ID exists in the input list.
- Go to the visual and in the Filters pane, drag the Filter_AssetID measure into the visual level filter section and set it to:
Filter_AssetID is 1
This will show only the records matching the entered Asset IDs
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
Hi ali_iopp,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
I think this wouldn't work for my use case, the issue is that report users want to search for an AssetID themselves and this solution I think does not work dynamically?