Forum Discussion
Export table with live connection
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 Rogaard , you are in the explore table preview mode in the semantic model layer there you can connect to the semantic model in live connection . But in report you dont have an live connection option .
Please refer to the below Msft documentation :
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-desktop
Hi Natarajan_M my problen is that I do not see this explore table anymore.
When I click on the sematic model I see this view and it changed for two weeks ago.
This is what I see when I qlick on the semantic model
Maby someone in my organisation has changed som settings I do know? 🤔
Maby it is just me who have lost it. 😩