Home Excel

Get and Transform Data

30 Conversations

Latest Activity

Custom List Message Item

Hello

 

Just wondering if there is a better way to do this.

 

I have built a form in Excel for my users to input data.

The data saves to a sheet in their workbook that is open when the form is in use. It automatically saves the Excel workbook with each form en

... Read More
18 Views
0 Reply

When I use PivotTables created from data connections, without the folder with the data table, the query becomes extremely slow. My laptop is a DELL with Intel Core I7 16MB RAM, good equipment. Has anyone encountered the same problem?

22 Views
1 Reply

Hi Marcelo,

 

I don't think your hardware is the bottleneck. Most probably that's how your queries are designed. There are lot of discussions about PQ/G&T performance, here

... Read More

Has anyone had a problem with date and time formats not being preserved in the downloaded table since the April Update?

 

I'm using Excel 2016 and all of my Get & Transform queries that are supposed to have columns with date and time formats in the resultin

... Read More
33 Views
1 Reply

Hi Douglas,

 

I'm on Excel build 16.0.8027.1008 (O365 8067.2018) and have no such issues

DatesRefresh.JPG

 

Read More

Hello

 

LInk : http://rajasthanindustries.org/ViewCompanyProfile.aspx?id=All&typet=alpha

 

There is a dataset which I want to get and transform using web, its in table but not able to identify , any trick to know which table has large data set 

 

Please suggest

Read More
38 Views
0 Reply

Such alert could appear when you try to use Power BI connector on Excel file. It's understandable if the source file is corrupted and can't be opened in Excel. However, it looks strange if Excel opens the file in question and shows nothing wrong.

 

Based on

... Read More
100 Views
2 Replies

I have this error but it seems to be computer specific, or more accurately Excel version specific. Using the same source files, a Power Query | Combine Binaries will work

... Read More

Hello, friends!
Could you give me a piece of advice with Get&Transform please?
In our company we have to use the information about sales in different reports, so I have some different excel files for different users. Each file contains a pivot table that co

... Read More
159 Views
8 Replies

Hello Nikita.

I'm not sure if the link below will help but I wanted to respond because I have a similar situation and think it is going to work for me. I'm not affiliated

... Read More

Nikita,

 

As i understood you have several Excel files with exactly the same query which you change from time to time. It could be several ways

 

1) Manually change query in

... Read More

I'm not sure I am able to do what I want to do without SQL functionality, but let's find out...

 

I have a table with 35,000 records (rows of data) with several columns of information for each. One column has an 8-digit industry code. There are a total of 3

... Read More
33 Views
1 Reply

Hi Micquelle,

 

Yes, with Get & Transform

1) Get data from first table, load query as connection

2) Do the same with second table

3) Merge first query with second one based on

... Read More

Chris Webb shared this https://support.office.com/en-us/article/Unified-Get-Transform-ad78befd-eb1c-4ea7-a55d-79d1d67cf9b3?ui=en-US&rs=en-US&ad=US&fromAR=1 link describing coming update of G&T.

 

Not available so far on my channel (build 1702.7870.2013).

Read More
113 Views
5 Replies

Hi Sergei,

 

it's for now available in the Office Insider Fast Ring, my current Version is 1703 Build 7920.1000.

 

Best,

Mourad

Read More

Hello,

 

I have followed all of the tutorials I can find on connecting to an Access Web App database via Excel, however keep receiving the following error message:

 

cannot_connect_excel_to_awa.png

 

Here is the tutorial that I have followed: https://blogs.office.com/2013/01/22/visualize-your-access-2013-web-app-data-in-excel/

... Read More
45 Views
1 Reply

I am wondering why you are using an old legacy Data Connection Wizard to connect to your SQL Server. Did you try using the Get & Transform SQL Server connector available

... Read More

I am using Power Query (Excel 2013) to gather sales and forecasting data.  The resulting Excel table is then used by Sales to update the forecast.  When forecast units are updated I need the resulting sales $ to update automatically.  Unfortunately, the u

... Read More
68 Views
2 Replies

Hi Ken,

 

PQ doesn't return formulas. I didn't catch what's your data structure, but why don't you do all transformations and updates by PQ, perhaps with help of Power Pivo

... Read More

Hello, friends!
Could you give me a piece of advice with Get&Transform please?
In our company we have to use the information about sales in different reports, so I have some different excel files for different users. Each file contains a pivot table that co

... Read More
22 Views
0 Reply

Hi friends,

 

We have recently announced the March 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in.

 

There are two new interesting features in this release:

  1. New transformation - horizontal list expansion.
  2. Enhanced SQL Server co
... Read More
101 Views
0 Reply

We recently updated from Excel 2013 to Excel 2016. All of my old Power queries were made using the latest version of power query but now since the upgrade to Excel 2016, I cannot get any of those queries to work. I keep getting the following error message

... Read More
123 Views
2 Replies

Hi David,

 

If you go into the Power Query Editor and click on each of the applied steps down the right hand side can you send us a screenshot of whichever step causes the

... Read More

This function always had two parameters as it is documented for today

Excel.Workbook(workbook as binary, optional useHeaders as nullable logical) as table

https://msdn.microsoft.com/en-us/library/mt260859.aspx

 

However, with the latest PQ update connector to

... Read More
109 Views
2 Replies

Hi Sergei!

 

Originally, Excel.Workbook used to read the entire workbook data to accuratly assign types to the columns. This was EXTREMELY slow on large workbooks.

 

Havi

... Read More

Hello all, I am new to these forums so forgive if I am doing anything wrong.

I have come across a problem with Power Query in Excel 2013.  I am importing from a Table in a different Excel workbook, I have removed some columns and i then want to sort the da

... Read More
123 Views
1 Reply

Hi Peter,

 

That could be bit abstract without knowing the details of you model, however,

- on PQ site try to isolate your table in memory using 'Add this data to Data Model

... Read More