Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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??
Solved! Go to 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.
@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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |