Custom Functions in Power Query

Peter079
Posts: 4
Joined: Mon Jul 24, 2017 7:58 pm

Custom Functions in Power Query

Postby Peter079 » Mon Jul 24, 2017 8:18 pm

Hi, I asked the same question at the Powerpivotpro forum but no response. My question is I have 8 accounting databases all set up in the same way (rows and columns). I have read a bit about custom functions in power query and its going over my head. The data does need a bit of work done to it before loading it into a data model. My question is does it matter whether I append all the data upfront (approximately 60 000 rows of data in total) and then carry out the transformations on the appended data set, or should I create a custom function in Power Query on one of the databases and then invoke the custom function to import the other 7 databases. There won't be any additional databases added in the future. Is there any difference between the 2 methods ?

Any help would be greatly appreciated

Peter

MattAllington
Posts: 1015
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Custom Functions in Power Query

Postby MattAllington » Tue Jul 25, 2017 7:30 am

Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

Peter079
Posts: 4
Joined: Mon Jul 24, 2017 7:58 pm

Re: Custom Functions in Power Query

Postby Peter079 » Tue Jul 25, 2017 7:13 pm

Thanks Matt

As always you come up with an answer that makes sense


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 2 guests