No announcements
Found 2456020 threads
-
0 VotesAnnoying bug in Excel Power Query Editor when selecting a query
I am experiencing a very strange but annoying bug in Excel Power Query Editor. When I select a Query ...Answered | 2 Replies | 399 Views | Created by martinitram - Thursday, October 17, 2019 11:53 AM | Last reply by - Friday, November 1, 2019 11:57 AM
-
0 Votes
Using Power Query annoying
say the format of a column, it takes 1 second. HOWEVER, if I use power query to grab from a database (or a CSV file) I have to change the format ...Discussion | 6 Replies | 612 Views | Created by AlexMartini - Wednesday, November 16, 2016 9:49 PM | Last reply by Imke Feldmann - Wednesday, November 23, 2016 7:46 PM -
0 Votes
Power query editor filtering
my dataset is 250,000,000 rows, too big for excel. in power query editor I filter column A and reduce the rows to ~1000, when I then ...Answered | 2 Replies | 494 Views | Created by Stevent88 - Tuesday, June 23, 2020 1:20 PM | Last reply by Ehren - MSFT - Thursday, July 9, 2020 5:41 PM -
0 Votes
Using Synonyms in query editor bug/feature
editor the tables in the linked server aren't listed, this I would say is not a bug just a fact. However when I create ... -
0 Votes
Power Query Expects Int when Query Editor doesn't
Hello, I am introducing a Power Query (over Excel Office 365) to a new organization in order to retrieve data from an ...Answered | 4 Replies | 435 Views | Created by Barak _ Bester - Tuesday, January 31, 2017 8:29 AM | Last reply by Curt Hagenlocher - Thursday, February 2, 2017 2:38 PM -
0 Votes
Power Query + Excel Connections
I tried making a connection using Excel's Data tab from another workbook to my Excel sheet with the power query-generated table. This works well except ...Answered | 1 Replies | 1012 Views | Created by Justin927 - Thursday, October 29, 2015 6:30 PM | Last reply by Mike Honey - Manga Solutions - Friday, October 30, 2015 2:01 AM -
0 Votes
Power Query Disappears from Excel
After opening a couple reports on excel designed with Power Query, the ribbon disappears from the top. The reports don't work because Power ...Answered | 1 Replies | 569 Views | Created by Andrew on Microsoft - Friday, June 2, 2017 6:42 PM | Last reply by David L Zhang - Wednesday, June 7, 2017 4:29 AM -
1 Votes
Obsolete Power Query in Excel 2016
In my daily work I have to use Power Query and PowerPivot, a couple of months ago I had an issue with Power Query and PowerPivot version ...Answered | 1 Replies | 769 Views | Created by pacheco4 - Monday, April 25, 2016 3:22 PM | Last reply by Alejandro Lopez-Lago - Wednesday, April 27, 2016 6:15 PM -
0 Votes
Numbers in a table are rounded in Power Query Editor
I have a table in Excel with values that are being rounded when opened in editor. The column type is decimal number so I don't ...Answered | 3 Replies | 774 Views | Created by DanielM31013 - Thursday, April 18, 2019 3:36 PM | Last reply by Ehren - MSFT - Monday, April 22, 2019 6:06 PM -
1 Votes
Power Query crashing when opening excel
Hi, Power query is crashing Excel when enabled. I have tried to reinstall and the error persisted even when I ran a clean ...Proposed | 2 Replies | 498 Views | Created by Roger.C - Monday, July 31, 2017 6:25 PM | Last reply by Emi Zhang - Friday, September 1, 2017 7:36 AM -
1 Votes
Excel 2016 power query editor VBA to copy entire table
actions to create a Power Query query, but these actions are performed in the Excel UI. The creation of a Power ...Answered | 4 Replies | 1078 Views | Created by kkaax - Wednesday, March 21, 2018 6:54 PM | Last reply by Jeff Reed _MSFT_ - Sunday, April 1, 2018 4:43 AM -
1 Votes
Power Query for Excel
I just installed Office Professional 2013 on a new computer. When I try to download Power Query for Excel for the 64-bit version, I get an error message ...Answered | 1 Replies | 594 Views | Created by Jan Murphy - Thursday, January 1, 2015 8:28 PM | Last reply by Ehren - MSFT - Wednesday, October 28, 2015 10:30 PM -
0 Votes
Excel 2013 Power Query setup
, you need to upgrade the Power Query public to Power Query Premium, this version of Power Query can be used in Office 2013 Professional ...Answered | 1 Replies | 648 Views | Created by ChadJH - Thursday, May 5, 2016 4:23 PM | Last reply by Emi Zhang - Friday, May 6, 2016 6:53 AM -
0 Votes
Power Query in Excel 2010
Hi amprophet, Based on your description, I suggest you post your issue to Power Query forum: httpsAnswered | 1 Replies | 450 Views | Created by amprophet - Friday, May 27, 2016 4:39 PM | Last reply by Emi Zhang - Monday, May 30, 2016 9:29 AM -
0 Votes
Power Query Editor -> View -> Query Dependencies - Collapse Window Hangs Excel - Task Manager Kill is only exit
dependencies diagram is via Power Query Editor and it is modal. Have to use Task manager to kill Excel. Any thoughts? -
1 Votes
Power Query In Excel - Load To Functionality
Apologies if these are stupid question I am very new to Excel Power Query, my background has mainly been in VBA. I currently have an ...Answered | 5 Replies | 2724 Views | Created by Emkay79 - Sunday, October 29, 2017 10:33 AM | Last reply by MoonlightTraveler - Thursday, March 28, 2019 5:36 PM -
0 Votes
Power Query - Bug in OData paging
Hi, I am currently running Power Query 1.5.3296.2082 in Excel 2013 x64 I have an OData service with an advanced paging ...Answered | 2 Replies | 2285 Views | Created by Uffe Lauesen - Tuesday, October 15, 2013 6:58 PM | Last reply by Curt Hagenlocher - Wednesday, October 23, 2013 10:37 PM -
1 Votes
Problem with Power Query in Excel 2016
I have had some issues with Power Query in Excel 2016 as well, specifically the a connection to Microsoft CRM, doesn't work in 2016 but works fine ...Answered | 2 Replies | 1799 Views | Created by Paul Levchuk - Friday, October 2, 2015 1:29 PM | Last reply by Paul Levchuk - Saturday, October 3, 2015 8:41 PM -
1 Votes
Excel Power Query Advanced Editor breaking code into steps
in power query and opened advanced editor to duplicate one of the steps (copied a line of code and changed column name)Answered | 2 Replies | 284 Views | Created by RY33 - Thursday, April 25, 2019 2:19 PM | Last reply by RY33 - Thursday, April 25, 2019 3:28 PM -
1 Votes
Query Editor
Where is the Query Editor in Excel 2010?Answered | 2 Replies | 755 Views | Created by Jessicasdd - Thursday, December 18, 2014 3:15 PM | Last reply by Jessicasdd - Thursday, December 18, 2014 9:09 PM - Items 1 to 20 of 2456020 Next ›
No announcements
