Is it possible to restrict the columns that Cortana looks up?

[Anonymous]

My dataset has columns that I do not necessarily want users to be able to filter the report by.  Using Cortana, however, a user could filter via that column if it asks the right question.

Is there any way to prevent this?  

The only thing I can think of is having a ISFILTER() statement for all my visuals, and to return BLANK() when true for those columns...

[v-shex-msft]

Hi @Anonymous,

I think you can simply to remove these columns from Q&A textbox to disable cortana look up.(Page Information -> Q&A')

 

For detailed information, you can take a look at below links:

Introduction to Cortana for Power BI

Use Power BI to create a custom Answer Page for Cortana

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Hmm, the column in question is not listed in that textbox, so I have to assume that it doesn't work that way.

Anyway, I ended up put an if statement in my measures so that if someone tries to filter it by the column, all the measures just return a blank.  It works, but at the bottom of the cortana is a link to "Open in Power BI"...  which shows the entire row including sensitive information.

Finally, I think I discovered the solution.  In the table, you can hide a column from the report view.  When I did this, I can no longer filter cortana queries by the column and it also removes it from all Q&A returns.  My actual report seems unaffected...