'Summarized Data' option acting crazy - is this a new feature?

[AliceW]

Hi everyone,

Exporting a table from a report using 'Summarized Data' resulted, until yesterday, in a beautiful pivot table.

However, I now get an additional 'Enable Content' button at the top and, what's worse, the columns:

- Are NOT exported in the order shown on the screen

- Have the FULL name (Table [Column]) as opposed to the name being displayed.

This is so bad.

What's going on?

Thanks,

Alice

[m-colbert]

This is exactly what is going on. You can somewhat control it with permissions (requires build permissions on the dataset). Or you can turn off globally in tenant settings for connecting direct to dataserts. A bit drastic and likely no what you want. Shame, that MS introduced this feature with this being the default selected option, it's thrown several of our heavy exporting users as well. 

[AliceW]

I really need to see how to fix this; the heavy exporters are not happy with it.

[m-colbert]

You can remove build permsssions or use the tenant settings. Its outlined in the article. Good luck!

[AliceW]

I have this for the workspace, and I can still see that option. I don't understand how to make it go away...

[AliceW]

Do I have to do this for all users? For all datasets?

https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-manage-access-permissions#m...

Update: actually TRIED THIS and that 'live connection' option is STILL THERE for one Viewer, and gone for another with the same access rights.

What's happening, people? 😞

[m-colbert]

@AliceW 

I'll try and play with this and what works and get to you.

[AliceW]

Thank you! It's so confusing for everyone.

[blopez11]

You will either need to remove build permission on the datasets for your consumers, or have them select the ".xlsx (Excel 150,000-row  max)" option for the file format, when exporting the summarized data.  Wish they would have left the old default as the new default as this could be confusing for the non-power users.

[AliceW]

But I tried removing the build permission and it only works for some users, even if all are set as Viewers without anything extra...

[AliceW]

On my reading list for tomorrow... ;(

[blopez11]

Likely this: https://powerbi.microsoft.com/en-us/blog/announcing-connected-excel-tables-from-power-bi/