Hi,
I have an XML data source that is returning a jagged number of levels/attributes.
DE is not interpretting this correctly as is coming across a level ...
4 Replies|90 Views|Last Post 10 hours 41 minutes ago
I am connected to a customer's network, but my computer is not joined to their domain. I am trying to use Data Explorer to query one of their SQL Servers.
All client tools ...
5 Replies|106 Views|Last Post Tuesday, June 18, 2013 4:05 AM
Howdy! I'm trying to connect to an OData feed. I navigate to it in the browser, it asks for credentials (Basic), I enter them, and then am presented with the metadata for the ...
1 Replies|67 Views|Last Post Monday, June 17, 2013 6:09 PM
Hi,
I'm trying to consume a restful service that needs XML posted to form the query. XML is then returned with the query results.
I've gotten as far making ...
1 Replies|77 Views|Last Post Friday, June 14, 2013 1:24 PM
Hi,
I was having trouble getting through our corporate proxy using Data Explorer. I found a solution that involves creating a file in the bin folder for Data Explorer ...
0 Replies|133 Views|Last Post Friday, June 14, 2013 12:30 PM
Hello,
I am searching a way to unpivot all my columns execpt the first one. Because the source files will grown in the future with other columns.
So, i try to ...
1 Replies|123 Views|Last Post Thursday, June 13, 2013 5:56 AM
Hello,
I don't find the way to split columns by Carriage Return from an Excel files.
My column have multi-rows cells and i want to create one row for each rows in ...
4 Replies|109 Views|Last Post Monday, June 10, 2013 7:03 PM
Hi all,
This seems like a dumb question, but still... I've built a query that takes data from a csv file and does some filters and transforms. It works fine, but I now want to take ...
5 Replies|701 Views|Last Post Monday, June 10, 2013 6:36 PM
On a couple of queries I've done (one html source, one excel table source) once the query has completed, I get the message that a number of rows were created but there were errors. How can I ...
2 Replies|120 Views|Last Post Sunday, June 09, 2013 5:35 PM
Hello,
I have just installed the Office 2010 Data Explorer add-in 32 bits.
When I try to use the Online search functionality I type the search term but the tools ...
1 Replies|239 Views|Last Post Thursday, May 30, 2013 5:14 AM
After importing a csv file with Data Explorer the third step is to split the first column by a delimiter. But curiously enough some of the rows will not be split up. This happens no matter what kind ...
3 Replies|311 Views|Last Post Monday, May 27, 2013 8:20 AM
It would be more the helpful to have a command to delete the last row of a table once it's imported by the Data Explorer. (This is usually a row which contains various sums for some of the ...
2 Replies|289 Views|Last Post Sunday, May 26, 2013 2:09 PM
I have been experimenting with using Data Explorer to extract data from a report that is formatted with headers and footers. I have been able to isolate the rows containing the data using DE's ...
2 Replies|332 Views|Last Post Thursday, May 23, 2013 10:43 AM
I get a message whne trying to install data explorer in Office 2010 x32 "There is a problem with this windows installer package. A DLL required for this install to complete could not be ...
1 Replies|347 Views|Last Post Wednesday, May 22, 2013 11:06 PM
Is there any way to run M language code (scripted from Excel) programmatically in other code eg: C#? I'd love to be able to use Excel to prototype a style of input, script out the M language code, and ...
1 Replies|346 Views|Last Post Monday, May 20, 2013 9:42 PM
In many cases, the tables that I want to import into Excel are spread over multiple source web pages, each with the same format, but with pagination (ie: a range of page numbers at the bottom of the ...
3 Replies|352 Views|Last Post Monday, May 20, 2013 9:33 PM
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.