Forum Discussion

TrevorCraig's avatar
TrevorCraig
Frequent Visitor
9 years ago

export to xlsx / underlying data

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. Wha...
TrevorCraig's avatar
TrevorCraig
Frequent Visitor
9 years ago

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's avatar
Michael1
Icon for Advocate II rankAdvocate II
9 years ago

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's avatar
    Michael1
    Icon for Advocate II rankAdvocate II
    9 years ago

    Hello:

     

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

     

    Thank you,

     

    Michael