Home

Get and Transform Data

48 Conversations

Latest Activity

Custom List Message Item

How does one link Excel data (just 6-8 fields) to automatically fill columns in a Sharepoint list when the document is uploaded.  Is a connection library needed?

24 Views
1 Reply

Hello,

 

you can create a SharePoint list from data in an Excel workbook, but after the list has been created, there is no further connection between the workbook and the l

... Read More

Hi all,

 

I have a question related to usage scenarios of the legacy Import from Web connector in Excel.

 1 - WebConnector.jpg

 

Today the legacy Import from Web connector supports the following features, which I’d like to get your perspective on:

  1. Importing the entire page.
... Read More
370 Views
7 Replies

I am a developer for an application which relies upon this for key reporting functionality.

 

It's only now, when trying to find out why it's broken, that I find out that t

... Read More

My exerience lately has been trying to help someone with the legacy connector because the target web page changed. After a couple rounds of click-here, try-this, I ask if

... Read More

Hi Guy,

 

Even though you only had one response up till now, I'd like to stress that that doesn't mean this feature isn't used much. I have a couple of customers that rely

... Read More
That's only my own experience - for many years used this feature quite seldom. These days Power Query connector to Web works fine for my purposes, even forgot about above... Read More

Hello Folks :)


As recomended by the Office Support page (link), I'd like to start a new conversation on how to ingegrate PostgreSQL in this forum as I cant find (after 2 hours of searching) any simple sollutions out there.


Am tyring to get Excel (2016 Profe

... Read More
35 Views
0 Reply

There is allegedly an option to import JSON data in XL 2016, but the option is missing in my copy. It isn't there in Customize the ribbon, so it can't be added from there, either. Any ideas where it got to?
 

XL2016-JSON-option-missing.png

Read More
176 Views
4 Replies

I don't have an Office 365 suscription.

I used "From Text" intead of "From JSON". Then select All filetypes, and you can open de JSON file. Hope it works for you too.

 

Rega

... Read More

Hi Noel,

 

I could be wrong but JSON data source was added not a long ago. If except insiders all new functionality goes first to O365 subscribers, and one day in future to

... Read More

Check out my suggestion on UserVoice.

 

Suggestion:

Using the legacy wizards, it is possible to refresh a "Microsoft Access Database" connection type in under a second, regardless of the number of tables being imported.

 

However, the new query imports from Ac

... Read More
33 Views
0 Reply

Assume there two tables.

One table contains the following:

  • A
  • B
  • C

The other table contains the following:

  • D
  • E
  • F

A full outer join, after expansion, should create a new table with two columns that look like this:

  • A D
  • A E
  • A F
  • B D
  • B E
  • B F
  • C D
  • C E
  • C F

Instead, this is returned:

  • A
... Read More
53 Views
3 Replies

Hi Stevenson,

 

That's correct behaviour for Full Outer join, it returns records from both tables with null in other column for not-matching records.

 

See, for example, http://www.dofactory.com/sql/full-outer-join

... Read More
Best Response

Hello,

 

I have created a data model within a workbook comprised of 15+ Excel data sources and 1-2 from SharePoint. The Excel data source files range from 10k-100k rows, which are located on our network drive. I use Get & Transform to pull in each of those

... Read More
51 Views
1 Reply

Hi @Michael Hang,

 

The refresh time is not unusual in my experience,  are you using 32 Bit Excel?

 

I'd encourage you to vote for this idea in the Excel User Voice forum to

... Read More

Hello,

 

I have created a data model within a workbook comprised of 15+ Excel data sources and 1-2 from SharePoint. The Excel data source files range from 10k-100k rows, which are located on our network drive. I use Get & Transform to pull in each of those

... Read More
20 Views
0 Reply

The old Text/CSV import wizard had not been updated since Office 2002/XP, looked old-fasioned, but it was very good at recognizing columns with dates. You could specify for instance YMD from a drop-down list and it even recognized yyyymmdd. Than suddenly,

... Read More
67 Views
1 Reply

Hi Willem,

 

Not exactly, old wizard is still here. You may add it from File->Options

 

LegacyWizards.JPG

 

Select it from Lecacy Wizards in Get data

 

LegacyWizards01.JPG

 

Alternatively you may call it from Tell Me

... 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
102 Views
3 Replies

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 want to add an inscription referred to at an arbitrary timing by referring to the saved final download time displayed as the download time of the preview data displayed in the query editor. Is it possible? It is assumed that the edit operation time and

... Read More
76 Views
0 Reply
Hi there,
We have several team members, each maintaining his/her own data in an excel file.
Managers are using an append Power Query (on excel 2013), to consolidate the data and create reports.
My question is: what if someone who uses this append result want... Read More
36 Views
1 Reply

Hi Karim

 

Ideally I'd add a "Assigned Team" field to my team members' source files to make it nice and simple.

 

However if you can't do that then It sounds like you'd need

... Read More

I am creating an Excel Online Survey in OneDrive for business with this article's procedure.

 

The survey works fine until a new column is added, in Excel Online's edit view, with an unique identifier for each row. At this point it seams as if the survey ce

... Read More
42 Views
0 Reply

Hi - just started learning Power Query / Get & Transform this month - what an incredible tool! My background is VBA, so getting data cleaned/shaped without writing any code is incredible!

 

Has anyone tried reading a XML Spreadsheet? Here's the header of my

... Read More
71 Views
1 Reply

Using Table notation, I can get directly to the data I need:
Data = Source{1}[Table]{0}[Table]{0}[Table]

 

But as I afeared, applying that to the original data set, I get th

... Read More

Hi, I am preparing the compensation revision letters for our employees. Different groups of employees have different allowances. If an employee does not have a fitness allowance for instance, can I get excel or word to suppress the field in the letter so

... Read More
36 Views
0 Reply