dataflow and looping data with function

[IF]

Hi,

I want to use dataflow in order to get data for my reports. However, I don't know if it is possible to use "invoke custom function" for data flows. 

For example; I want to extract one month of data from my source. I put month parameter in order to get the data for a month. Later on I develop a new column in the table based on a parameter that I made. Later on I develop a function at the dataflow (app.powerbi.com). Until this stage everything is fine. I have another table for listing the months. I want to invoke that table with the function in order to get data for more than one month. However, there is no option to use "invoke custom function" at the dataflow menu. Actually this is possible at the desktop version. Does anyone know if I can loop the data by using dataflow in this way or another way?

All the best,

[ibarrau · Accepted solution]

Hi, I'm not sure about the whole explanating, but you can invoke custom function in dataflows. You can basically do almost everything that the query editor does. If you don't find a way and you have it in desktop you can right click on a table and copy to paste in dataflows. You can also copy paste the advanced editor power query code in a data flow blank query for your custom function. Example: https://www.youtube.com/watch?v=YWp4FKzIBxM

Hope this helps,

Regards,

[IF]

Hi,

The second option works. Thanks.

I am not sure about the first one. At least, I don't have that option as you can see from the screenshot.

Regards,