Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
DisclosureUser
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
ankitpatira
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
ankitpatira
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

 

 

 

 

 

 

 

 

 

 

 

 

 

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

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.