Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Stop loading all data in Live Connection in every controls refresh

Hi,

I use Analysis Services and Live connection with my reports.

I have problem with poor performance of the report. In my report I have collapsible filters. 

All translated texts in the report are loaded from Analysis Services every time when I expand and collapse filters in the report. 

Question: is there possibility to not load these translation data always when I show and hide translated labels (there are Card or Advanced Card controls).

 
 
 
 
Need Help

4 Replies

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    You can try to disable interactions between your translated text visual and your filter.

    For details, please refer to this document: Change how visuals interact in a Power BI report.

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • jessegorter's avatar
    jessegorter
    Icon for Helper I rankHelper I
    6 years ago

    The question is; when you change a filter, does it need to filter the text? You cannot only do a data refresh when you unhide/collapse data as far as I know.

    If the data labels do not need to be filtered, either change the relationships between tables or change filter interaction, shown above.

    • Icey's avatar
      Icey
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi jessegorter ,

       

      You are right. Sorry, I didn't make it clear above.

       

      Best Regards,

      Icey

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    When I precisely analysed Performance analyzer logs I saw that not loading data from Analysis Services is a problem.

    The problem are custom controls that I have on the report, like: Advance card, Chiclet slicer and Hierarchy slicer.

    So I will focus on different issue.

     

    Thank you!