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

[jasonrutherford]

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!

[AlB · Accepted solution]

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