No announcements
Found 77 threads
-
0 Votes"Data Explorer" is now "Microsoft Power Query for Excel"
Along with the Power BI related announcements at the Worldwide Partner Conference on July 8 2013, we are pleased to announce that Microsoft Power Query for Excel (previously known as codename ...
-
0 Votes
Load to model without loading to worksheet
Hi all, I'm working with some reasonably large text files, and one frustrating problem I'm running into is that I can't load data into the Excel data model without loading it onto ...Unanswered | 7 Replies | 4288 Views | Created by Christopher Webb - Monday, July 1, 2013 1:22 PM | Last reply by Faisal Mohamood [MSFT] - Friday, July 5, 2013 5:04 PM -
0 Votes
Use Data Explorer to import from a folder containing multiple Excel files
I have the following scenario: A shared folder contains multiple excel files, all based on the same structure. I would like to use Data Explorer to combine a named worksheet ...Unanswered | 0 Replies | 4486 Views | Created by Bertrand d'Arbonneau - Friday, July 5, 2013 8:07 AM -
0 Votes
OLEDB connection from Data Explorer add-in
Hello, I am testing out the new Data Explorer add-in. Previously, in the Data Tab, I could use the Connection Wizard to create an OLEDB connection to an OLEDB provider. ...Unanswered | 1 Replies | 4782 Views | Created by scotth_owl - Sunday, June 23, 2013 9:48 PM | Last reply by Zafar Abbas - Thursday, July 4, 2013 7:47 PM -
0 Votes
Make the UI more visible
I've been using Data Explorer now for a couple of weeks and I've only just discovered the menu after clicking in the corner and on column headings. Not realising ...Unanswered | 1 Replies | 4599 Views | Created by Nelson Jones - Tuesday, July 2, 2013 12:02 PM | Last reply by Peter Qian - MSFT - Tuesday, July 2, 2013 8:55 PM -
0 Votes
Web.Contents() and HTTP headers
Hi, After seeing that Lee's been successful with his web service, I've started looking at whether it's possible to use Web.Contents() to generate a POST request that can be used to ... -
0 Votes
Unpivot
Here's a short post on how I managed to unpivot some data I had. Many queries made to business data return months in columns. This is not ideal as it's easier ...Discussion | 2 Replies | 4442 Views | Created by Nelson Jones - Monday, July 1, 2013 2:10 PM | Last reply by Nelson Jones - Tuesday, July 2, 2013 11:58 AM -
1 Votes
Data Explorer not working with the "runas" command
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 ...Answered | 8 Replies | 6776 Views | Created by Craig Bryden - Thursday, June 13, 2013 3:55 AM | Last reply by WGCL1 - Sunday, June 30, 2013 11:33 AM -
0 Votes
oAuth for Twitter search API 1.1
Hi Miguel I'm trying to follow your oAuth instructions for a Twitter search (API 1.1) without any ...Unanswered | 0 Replies | 5580 Views | Created by Mike Honey - Manga Solutions - Friday, June 28, 2013 6:36 AM -
0 Votes
Problem Combining Queries
let Source = Web.Page(Web.Contents(“http://espn.go.com/nba/salaries/_/page/” & Number.ToText(page))), Data0 = ...Proposed | 1 Replies | 4417 Views | Created by bpovlins - Monday, June 24, 2013 4:02 AM | Last reply by Andrew [MSFT] - Tuesday, June 25, 2013 11:37 PM -
0 Votes
Data Explorer plans
Are there any plans to enable Data Explorer queries to be pushed up to the server/cloud and set refresh cycles? I'm thinking that with the loading to PowerPivot and possibly Tabular ... -
0 Votes
Convert Xml CData to Table
Hi, I'm calling a web service that returns XML with a column of CData (commar delimted text) The query producing this ...Unanswered | 2 Replies | 5510 Views | Created by Nelson Jones - Monday, June 24, 2013 2:29 PM | Last reply by Nelson Jones - Monday, June 24, 2013 3:02 PM -
0 Votes
Error authenticating with OData
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 ...Unanswered | 2 Replies | 4560 Views | Created by Richard A Simpson - Monday, June 17, 2013 5:47 PM | Last reply by Keith Gatton - Thursday, June 20, 2013 8:24 PM -
0 Votes
Jagged levels within XML
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 ...Unanswered | 4 Replies | 4416 Views | Created by Nelson Jones - Friday, June 14, 2013 1:57 PM | Last reply by Andrew [MSFT] - Tuesday, June 18, 2013 7:46 PM -
0 Votes
Posting XML to a Restful service
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 ...Answered | 1 Replies | 11779 Views | Created by Nelson Jones - Friday, June 14, 2013 1:00 PM | Last reply by Nelson Jones - Friday, June 14, 2013 1:24 PM -
1 Votes
Using Data Explorer behind a proxy - solution
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 Votes
How to : Unpivot Other Columns
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 ...Answered | 1 Replies | 5736 Views | Created by Simon Poslednik - Wednesday, June 12, 2013 2:15 PM | Last reply by Peter Qian - MSFT - Thursday, June 13, 2013 5:56 AM -
0 Votes
Split columns by CR in excel cells
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 ...Answered | 4 Replies | 5355 Views | Created by Simon Poslednik - Monday, June 10, 2013 7:40 AM | Last reply by Simon Poslednik - Monday, June 10, 2013 7:03 PM -
0 Votes
Change Source
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 ...Answered | 5 Replies | 5500 Views | Created by Christopher Webb - Monday, March 4, 2013 4:28 PM | Last reply by s.waltman - Monday, June 10, 2013 6:36 PM -
0 Votes
The query could not be found.
Hello, When I open one workbook an Excel message says "the query 'resource list' could not be ...Answered | 3 Replies | 4697 Views | Created by Stéphane Guilleminot - Thursday, June 6, 2013 12:16 PM | Last reply by Miguel.Llopis - Sunday, June 9, 2013 6:52 PM - Items 1 to 20 of 77 Next ›
No announcements
