Custom Functions Made Easy in Power BI

Рет қаралды 34,011

Күн бұрын

I have written a lot about Power Query M scripting language, and how to create custom functions with that. With recent updates of Power BI Desktop, creating custom functions made easier and easier every month. This started with bringing Parameters a few months ago and adding source query for the function in November update of Power BI Desktop. In this video you will learn how easy is to create a custom function now, what are benefits of doing it in this way, and limitations of it. If you like to learn more about Power BI; read Power BI online book from Rookie to Rock Star.
To read the details through my blog post, follow this link:
radacad.com/custom-functions-...

Пікірлер: 54

@stephencross4669 4 жыл бұрын

Can’t tell you how long I looked for a video on this topic. Definitely opens the door to solving many of my problems.

@cleophusjohnson733 5 жыл бұрын

Awesome tutorial Reza! I learned a lot!

@astatine0085 9 ай бұрын

This is a symphony! Thank you! I have been churning examples for hours, and I finally have my solution.

@RADACAD 9 ай бұрын

Glad it helped!

@shirleysmith3409 3 жыл бұрын

Thank you!! This is a wonderful video. Solved a big problem I was having with Dataflows and also improved the way I write queries.

@snafuanalyst717 3 жыл бұрын

Excellent tutorial on a topic that had me banging my head on my desk for years!

@AjitUnni 4 жыл бұрын

Great video, Reza. You are a natural teacher

@AlbrechtJ 2 жыл бұрын

Thanks for this hidden gems. Rarely to find someone teach this advance topic.

@RADACAD 2 жыл бұрын

Glad you enjoyed it!

@curtisashley7037 3 жыл бұрын

Awesome video! Instructions were crystal clear. Thank you for sharing.

@kanth555 4 жыл бұрын

Thanks a ton, I was searching for this technique and this helped me :-)

@KerryEmerson 3 жыл бұрын

Great tutorial. Does Power BI 'import' all the data specified as the source, or can this be used for dynamic API queries?

@user-hu7ov6fi9y 3 жыл бұрын

Mind-blowing function. Raza, thanks for explaining this.

@jryan121 Жыл бұрын

Amazing tutorial - Cannot thank you enough for making this!

@peterh7842 2 жыл бұрын

That's great - really clear but any chance of an example with more than one parameter - been requested a few times here and there are no videos on the web that I have been able to find?

@ccrosetti12 2 жыл бұрын

Great video Reza - do you have a similar one but connecting to an OData source with authentication?

@kennethstephani692 4 жыл бұрын

This is a terrific video - very, very informative!!

@eduardodutra3294 4 жыл бұрын

Thanks! You helped me a lot!

@samama1975 4 жыл бұрын

Beautiful! Thank you!!

@kaveharshadi9632 5 жыл бұрын

Very useful. Thanks a lot again.

@alexvetrow6049 3 жыл бұрын

Wow, thank you so much for this video. Now scraping websites is much easier.

@novak2033 5 жыл бұрын

amazing! thanks a lot!

@dritans7334 Жыл бұрын

Great explanation. I have a scenario that when I try to expand and get the column I need after I invoked custom function I get this error: Expression.Error: Evaluation resulted in a stack overflow and cannot continue. Any idea how to work this around?

@terpstry 5 жыл бұрын

Great tutorial. Thanks

@luzernchan5691 4 жыл бұрын

Hi there, thanks for the video. if I want to pass two variable into the function, what needs to be done differently ? I used the method in this tutorial, but don't seem to get it working.

@RADACAD 4 жыл бұрын

You need to add more parts in it, and add more parameters in the URL

@apodim8874 5 жыл бұрын

THANK YOU!!!

@ChrisSmithFW Жыл бұрын

Fantastic! Thank you!

@RADACAD Жыл бұрын

Glad you liked it!

@ivavucak9863 Жыл бұрын

Thank you for this video it is really helpful!

@RADACAD Жыл бұрын

Glad it was helpful!

@kabitapaul9641 3 жыл бұрын

Hi , your videos are great, those are really very helpful. I am migrating one Angular application to Power BI where I have use case like user can select which columns they want to see and the grouping columns and X axis dimension column. Data source is Snowflake (direct query) where I cannot modify the native query. "view native query" option is disabled. I was able to achieve dynamic dimension through dynamic binding of parameters. But grouping column can be one or many which I am not able to achieve. This looks very challenging and I am not sure whether it is at all possible with Power BI. I can send screenshots for the problem if you can provide any email Id.

@TheBirdChannelOriginal 2 жыл бұрын

Great explanation!, what if I want to get the same data from Google Big query (over 100 same tables), how should I define and embed the parameter in the Advanced editor?

@TheBirdChannelOriginal 2 жыл бұрын

I could manage it by replacing date with a new parameter name. for example 20220202 should be "&NewParameter&"

@not_AI_bot 4 жыл бұрын

It looks like the officeholidays.com has changed their table. They removed all date. They now showing the date with format "Jan 28" without year. The problem is the auto convert to date, since it is no year, then it automatically insert the current year. Is there any easy way?

@phoenixflower1225 3 жыл бұрын

.. Is so awesome! TY

@CoopmanGreg 4 жыл бұрын

Great Video!!

@PranayPawar1991 2 жыл бұрын

So well explained

@user-lm5wb8vi1x 4 ай бұрын

Finished watching

@srinivaselluri9267 3 жыл бұрын

Hi Reza, How can I translate this to Power BI online? I am able to create a invoke function with two date parameters and getting desired results in desktop. But when I publish it, I don't see that input parameter option to enter the data, Please help. Thank You

@AI-Health-posts 5 жыл бұрын

Great video. Can you please make video on passing power Bi microsoft exam 70 778

@odel_leal 4 жыл бұрын

Thank you

@deepaksahu3349 3 жыл бұрын

Great Video, One question: If we want to fetch data for multiple countries and multiple years what we need to do ?

@RADACAD 3 жыл бұрын

you would need one parameter for the country and one for the year. However, because every country's data table format might be different you may also need a separate function for each country too.

@doniyellin7111 4 жыл бұрын

What about making a parameter that changes daily if the website also changes daily?

@doniyellin7111 4 жыл бұрын

Is there a way to automatically change the data source in PBI daily via an equation (for example: add 8340 to the middle number in the link every day. So day 1 would by 8340, day to would automatically change to 16680, etc)? Thank you!