Forum Discussion
Export table with live connection
- 6 months ago
Hi Rogaard ,
If I understand your requirements correctly, you need to export data with a live connection. To do this, you can use the 'Analyze in Excel' option, which allows your semantic model to maintain a live connection within Excel.
Alternatively, if you want to perform ad hoc analysis in the service, you can use the 'Explore Data' feature. This lets you either create a blank report or explore existing data, where you can drag and drop columns and measures to build the visuals you need.
Thanks
If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster
Hi,
First on Desktop file make sure 'More Options' is switched on under Header Icons, Property.
Then 'Hide the visual header in reading view' box is NOT checked for both Option on desktop file and setting in Service.
Then the '...' would appear on top right corner of the visual with Export feature.