cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
great_AS Member
Member

Invoked custom column

Hi everybody,

 

I'm copying from the advance editor all the steps from the file of a colleague of mine. Unfortunately, it returns me an error.

 

Therefore, I went backward to check alll the steps and I figured out that the second step, an invoke custom column is perceived as a normal custom column. Hence, I decided to insert a brand new step and invoke a custom column  but it looks like I cannot select the function query. Any explanations and suggestions?

 

2017-05-17 11_26_58-.png

1 ACCEPTED SOLUTION

Accepted Solutions
MarcelBeug Super Contributor
Super Contributor

Re: Invoked custom column

This video illustrates how to copy AND how it solves the issue:

Specializing in Power Query Formula Language (M)

View solution in original post

10 REPLIES 10
MarcelBeug Super Contributor
Super Contributor

Re: Invoked custom column

Probably you don't have the custom function.

 

If you copy a query, it is better to right-click the query, choose copy, and paste in the query editor of the destination file.

 

This will copy/paste the query plus all related queries, like the custom function in your case.

 

If you copy/paste the query steps, then you will only get the query steps; not any related queries.

 

For now I would suggest to copy/paste the custom function as well.

Specializing in Power Query Formula Language (M)
great_AS Member
Member

Re: Invoked custom column

Hi @MarcelBeug,

 

what I did was to copy and paste the steps from the advance editor in the query editor.

 

As you can see from the file attached, the second step should be a Invoke custom columns but it's not.

 

2017-05-17 11_51_11-Business Review Tool_V2 - Query Editor.png

MarcelBeug Super Contributor
Super Contributor

Re: Invoked custom column

That is exactly what I tried to explain: because you didn't copy the function, the step isn't recognized as a step in which a custom function is invoked.

And that is why you get the error message, because "Transform File from ESDS (2)" doesn't exist

 

So just go back to your colleague and copy his "Transform File from ESDS (2)" function and paste it in your file.

 

Specializing in Power Query Formula Language (M)
great_AS Member
Member

Re: Invoked custom column

THanks @MarcelBeug, how do I copy it?

MarcelBeug Super Contributor
Super Contributor

Re: Invoked custom column

This video illustrates how to copy AND how it solves the issue:

Specializing in Power Query Formula Language (M)

View solution in original post

ayushnigam268 Regular Visitor
Regular Visitor

Re: Invoked custom column

What if I have no option to copy the function from anywhere? What should be my best practice then?

MarcelBeug Super Contributor
Super Contributor

Re: Invoked custom column

Create it from scratch?

 

Seriously: what do you mean exactly:

do you have no access to the source code, or

are you not allowed to copy, or

is there no source code at all?

Specializing in Power Query Formula Language (M)
ayushnigam268 Regular Visitor
Regular Visitor

Re: Invoked custom column

I got the same error when I started from scratch. How do I get access to source code?

MarcelBeug Super Contributor
Super Contributor

Re: Invoked custom column

What are you trying to do and what is the error message?

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 49 members 1,202 guests
Please welcome our newest community members: