Forum Discussion

jasonrutherford's avatar
jasonrutherford
Regular Visitor
5 years ago
Solved

Gathering data from a function (the function is stored as abstract data)

I'm working PowerBI and the Azure Graph API. Some of the data returned is a function and i'm looking for some guidance on how to iterate through (each) record, invoke the function, and store the results of the function in antoher table... I'm good if we just add columns to the current table as well.

 

thanks!!

 

 

Any help is appreciated!

 

 

  • Hi jasonrutherford 

    You can simply create a custom column with code:

     

    = [getNonCompliantSettings](parameter1, parameter2)

     

    where (parameter1, parameter2,...) will depend on the function of course 

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

     

1 Reply

  • AlB's avatar
    AlB
    Community Champion

    Hi jasonrutherford 

    You can simply create a custom column with code:

     

    = [getNonCompliantSettings](parameter1, parameter2)

     

    where (parameter1, parameter2,...) will depend on the function of course 

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers