How to get data from an XML string in a SQL Server database

[DisclosureUser]

I'm evaluating Power BI for possible purchase- not liking it all so far.

I need to get LOTS of data from a SQL Server column that is datatype of XML. In a SQL statememt this looks like this:

select Data.value('/Section1[1]/eStudy[1]/eClientNumber[1]', 'nvarchar(15)')

Where/how do I do this?

I have hundreds of SQL queries already written, I just want to paste them in somewhere and then visulize from the results. Can I do that??

[ankitpatira · Accepted solution]

@DisclosureUser There are couple of ways,

1. When connecting to sql server from power bi desktop you have option to execute sql statement.

2. Export table out as XML from sql server and then import that xml file into power bi.

[Markzolotoy]

Any chance you could provide more details on how to export a result of an SQL statement into an xml file?