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 d...
  • 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

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

      • marcinkranz's avatar
        marcinkranz
        Frequent Visitor
        8 years ago

        That's what I figured. Thanks.