Forum Discussion

marcinkranz's avatar
marcinkranz
Frequent Visitor
8 years ago
Solved

Quick Insights analyzing hidden data

I recently started using Power BI to analyze and present my spreadsheets, but I've come across a problem with Quick Insights.

 

I read here that you can optimize quick insights by hiding data you don't want it to analyze. However, even after hiding all irrelevant columns and sheets, Quick Insights continues to only return analysis on the same hidden data.

 

Thanks in advance for any help.

 

 

  • Anonymous's avatar
    Anonymous
    8 years ago

    marcinkranz，

    Hiding columns refer to that hide columns in Power BI Desktop. Hiding sheets in Excel will not impact the analysis of Quick insights.


    Regards,
    Lydia

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    marcinkranz,

    I am unable to reproduce this issue after hiding columns in my PBIX file. What do you mean by "hide all sheets"? Do you use these hidden columns to create visuals? Could you please share your PBIX file so that I can test?

    Regards,
    Lydia

    • marcinkranz's avatar
      marcinkranz
      Frequent Visitor
      8 years ago

      I was hiding sheets in the source excel file which was linked to the browser version of power bi through one drive for business. I guess hiding sheets in excel doesn't hide it from quick insights.

       

      It turns out I actually don't need a solution on this anymore, as I decided to not use quick insights for my analysis.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        marcinkranz，

        Hiding columns refer to that hide columns in Power BI Desktop. Hiding sheets in Excel will not impact the analysis of Quick insights.


        Regards,
        Lydia