export to xlsx / underlying data

[TrevorCraig]

Hi,

Is there any documentation on this new bit of functionality? We're slightly concerned that users will be able to export fields from the underlying dataset we're not showing on the report. What is exported from visuals doesn't seem to pick up all the dataset fields anyway and I can't find anywhere that defines what is/isn't exportable in datasets.

Thanks, keep up the good work! 😄

[MattAllington]

If your data is in the data model, you should assume that the user can get to the data.  There are 2 things

1.  Any visual can export the underlying summarised data to render the visual (I guess you know that).

2.  There is an "Analyze in Excel" feature that basically allows anyone to get to all the data.  There is a config option to turn off Analyze in Excel however this is currently at the Tennant level - it is either on or off for everyone and for every report.  There are requests in to change this setting to be at the report level however there is no clarity if or when this may be changed.

Read Ken's blog on this topic from a couple of weeks ago

http://www.excelguru.ca/blog/2016/11/07/can-users-see-my-raw-data-in-power-bi/

[TrevorCraig]

Thanks Matt, useful information. I think we've got analyze in excel turned off but I'm going to double check! We've started putting HR data into power bi and its going to be a massive pain creating almost identical data models as a way of having granularity on what certain groups can see in what is basically the same report but with some fields hidden for certain users. The export to excel also appears to be inconsistent on what columns you get from the data table compared to the export to csv. I'll wait and see how it pans out, if enough users have concerns I'm sure MS will look to implement so ways to better manage these issues. 

[Michael1]

Hi,

I've also observed that the column sequence is different between an .xlsx and a .csv export.  I would think my columns should be the same as in the visual table?

Also--does anyone know how to change the sequence of the columns in the export when the user does not do a .csv?

Thanks!

Michael

[Michael1]

Hello:

Are there any updates, additional information to having the default column sequence appear what is on the visual?

Thank you,

Michael