Missing power query functions

stigcorneer

New Member
Joined
Nov 14, 2018
Messages
6
Hi,
I have a Excelfile with a power query model in it.
It works fine on one computer, but when I run it in on another computer there are errors.

I use excel 2016 on both computers but the one with errors crashed a couple of weeks ago and got office reinstalled just the other day.

The error seem to appear in this function:
Table.TransformColumns(#"Transponerad tabell1", {{"Column1", each Text.AfterDelimiter(_, "Column"), type text}})

When I look at the power query window the function "Text.AfterDelimiter" just isn't there on the second computer.
Is it possible that some of the M functions are missing from the computer and how do I repair it?
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,231
maybe on the "error" computer try replicate this from the ribbon - extract - Text After Delimiter
if there is an error you should see this on the yellow bar in PQ Editor
 
Last edited:

stigcorneer

New Member
Joined
Nov 14, 2018
Messages
6
I get this error message:
"Expression.Error: The name Text.After Delimiter was not recognised. Check the spelling"
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,231
The name Text.After Delimiter was not recognised. Check the spelling
should be: Text.AfterDelimiter no space,
like: Text.AfterDelimiter(blablabla, ",")
or post your M-code here
 
Last edited:

Forum statistics

Threads
1,077,895
Messages
5,337,054
Members
399,120
Latest member
Sravankumar

Some videos you may like

This Week's Hot Topics

Top