Forum Discussion
Solved
How to get data from an XML string in a SQL Server database
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: sel...
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.
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.
Any chance you could provide more details on how to export a result of an SQL statement into an xml file?
