Quick Insights analyzing hidden data

[marcinkranz]

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.

[v-yuezhe-msft]

@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]

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.

[v-yuezhe-msft · Accepted solution]

@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]

That's what I figured. Thanks.