Remove data from Excel to force refresh against tabular model RRS feed

  • Question

  • I have a simple excel connected to azure analysis services tabular model via an ODC file connection, works great, problem is I want to distribute this file to others and have it not save the data so it forces the user to authenticate and their row level security restrictions limit them to see what they have access to rather than when i saved the file the copy of data that is initially visible. 

    I'd like to somehow build my excel sheet and save it without data but the option in the connection properties for "remove data from the external data range before saving the workbook" is disabled and grayed out. 

    Tuesday, October 29, 2019 10:03 PM

All replies

  • Hello , 

    If other users need to see the data which they have access to , why are we sending more data ? I mean when they try to connect to the AAS , they will access the data to which they have access to . Sorry can you please elaborate the ask so that we can help ?

    Thanks Himanshu

    Thursday, October 31, 2019 10:48 PM
  • Becker3, if you are still facing the issue, let us know, otherwise we will assume you found your own solution.
    Thursday, November 7, 2019 7:27 PM