Forum Discussion

madji's avatar
madji
Helper I
9 years ago

Cycle in Power BI

Hi, everyone!

I hope you can help me.

 

 

 

 

 

 

 

 

 

 

I have one main table, one of this column has link.

This link I try to use as source for my new table.

 

I try to create the variable and cycle. I want to get one table as the table position(2) with all links.

 

Thanks a lot!

 

2 Replies

  • Hi madji,

     

    What you are trying to achieve is possible.

     

    Please try connecting to a web page first and then do your transformation. . After pulling the needed table and have transformed it to your desired shape, you can convert the query created to a custom function. 

     

    You may study this tutorial: http://radacad.com/custom-functions-made-easy-in-power-bi-desktop

    You may also post your query editor code here and then I can convert it to a function.

     

  • Hi, everyone!

    I hope you can help me.

     Main Table

    I have one main table, one of this column has link.

    This link I try to use as source for my new table.

     

    I try to create the variable and cycle. I want to get one table as the table position(2) with all links.

     

     New Table

     

    Thanks a lot!