Thankyou for this video. Most of the videos show how to create custom functions but do not show how to use it later. This is what I was looking for for an hour.
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?
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?
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.
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?
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?
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!
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.
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
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.
Thankyou for this video. Most of the videos show how to create custom functions but do not show how to use it later. This is what I was looking for for an hour.
Thanks for this hidden gems. Rarely to find someone teach this advance topic.
Glad you enjoyed it!
Can’t tell you how long I looked for a video on this topic. Definitely opens the door to solving many of my problems.
This is a symphony! Thank you! I have been churning examples for hours, and I finally have my solution.
Glad it helped!
Excellent tutorial on a topic that had me banging my head on my desk for years!
Thank you!! This is a wonderful video. Solved a big problem I was having with Dataflows and also improved the way I write queries.
Awesome tutorial Reza! I learned a lot!
Wow, thank you so much for this video. Now scraping websites is much easier.
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?
Awesome video! Instructions were crystal clear. Thank you for sharing.
Great video, Reza. You are a natural teacher
Mind-blowing function. Raza, thanks for explaining this.
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?
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.
You need to add more parts in it, and add more parameters in the URL
Great video Reza - do you have a similar one but connecting to an OData source with authentication?
Amazing tutorial - Cannot thank you enough for making this!
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?
I could manage it by replacing date with a new parameter name. for example 20220202 should be "&NewParameter&"
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?
Great tutorial. Does Power BI 'import' all the data specified as the source, or can this be used for dynamic API queries?
What about making a parameter that changes daily if the website also changes daily?
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!
Great Video, One question: If we want to fetch data for multiple countries and multiple years what we need to do ?
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.
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
Thanks a ton, I was searching for this technique and this helped me :-)
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.
Thank you for this video it is really helpful!
Glad it was helpful!
Great video.
Can you please make video on passing power Bi microsoft exam 70 778
This is a terrific video - very, very informative!!
Very useful. Thanks a lot again.
IS THIS LECTURE IN HINDI????
Thanks! You helped me a lot!
So well explained
Great tutorial. Thanks
Finished watching
Beautiful!
Thank you!!
amazing! thanks a lot!
.. Is so awesome! TY
Great Video!!
THANK YOU!!!
Great video
Thank you
You mastermind
awesome
Fantastic! Thank you!
Glad you liked it!