Custom Functions Made Easy in Power BI

[@stephencross4669]

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

[@astatine0085]

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

[@RADACAD]

Glad it helped!

[@AlbrechtJ]

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

[@RADACAD]

Glad you enjoyed it!

[@snafuanalyst717]

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

[@shirleysmith3409]

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

[@cleophusjohnson733]

Awesome tutorial Reza! I learned a lot!

[@peterh7842]

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?

[@alexvetrow6049]

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

[@ccrosetti12]

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

[@SandipanSarkar-c8v]

Finished watching

[@KerryEmerson]

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

[@user-hu7ov6fi9y]

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

[@AjitUnni]

Great video, Reza. You are a natural teacher

[@curtisashley7037]

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

[@jryan121]

Amazing tutorial - Cannot thank you enough for making this!

[@not_AI_bot]

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?

[@luzernchan5691]

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]

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

[@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?

[@deepaksahu3349]

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

[@RADACAD]

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.

[@TheBirdChannelOriginal]

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]

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

[@PranayPawar1991]

So well explained

[@Imrannaseem818]

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

[@kabitapaul9641]

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.

[@kaveharshadi9632]

Very useful. Thanks a lot again.

[@ivavucak9863]

Thank you for this video it is really helpful!

[@RADACAD]

Glad it was helpful!

[@srinivaselluri9267]

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

[@kanth555]

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

[@apodim8874]

THANK YOU!!!

[@terpstry]

Great tutorial. Thanks

[@eduardodutra3294]

Thanks! You helped me a lot!

[@odel_leal]

Thank you

[@kennethstephani692]

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

[@samama1975]

Beautiful! Thank you!!

[@doniyellin7111]

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

[@doniyellin7111]

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!

[@novak2033]

amazing! thanks a lot!

[@phoenixflower1225]

.. Is so awesome! TY

[@SuperAzizx]

awesome

[@CoopmanGreg]

Great Video!!

[@Amuppet]

You mastermind

[@jjpreston29]

Great video

[@powerbis.1794]

IS THIS LECTURE IN HINDI????

[@ChrisSmithFW]

Fantastic! Thank you!

[@RADACAD]

Glad you liked it!