Forum Discussion

ali_iopp's avatar
ali_iopp
Frequent Visitor
1 year ago
Solved

Using a text filter and getting around Direct Query row limit

Hi, I would like for users to enter an `Asset ID` (or collection of `Asset ID`s) into a text slicer, this is linked to a table of records related to the Asset ID. The issue I have is that due to vol...
Need Help
Tips and Tricks
  • ajohnso2's avatar
    ajohnso2
    1 year ago

    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's avatar
ajohnso2
Solution Supplier
1 year ago

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.

  • ali_iopp's avatar
    ali_iopp
    Frequent Visitor
    1 year ago

    Though this isn't really a solution to the stated problem, I was able to use the incremental refresh in addition to model improvements to change the report away from direct query mode and thus solved the issue of the 'broken' slicer, thanks for the tip ajohnso2 

    • v-achippa's avatar
      v-achippa
      Community Support
      1 year ago

      Hi ali_iopp,

       

      Thank you for the response and confirming that the issue is resolved. I request you to please accept the post as "Accept as Solution" so that other community members who has similar issue will find it more easily.

      Thank you for being part of  Microsoft Fabric Community.

       

       

      Thanks and regards,

      Anjan Kumar Chippa