cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

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:

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??

1 ACCEPTED SOLUTION
Community Champion
Community Champion

@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.

 

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

View solution in original post

2 REPLIES 2
Community Champion
Community Champion

@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.

 

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

View solution in original post

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

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors