Forum Discussion
GlenWillms
Jul 13, 2022Employee
I don't have the ability to test this, but you may be able to use Power Query in Excel (or Power BI) to pull the AFM rules straight into Excel for easy data refreshes.
Here is a link (https://community.powerbi.com/t5/Power-Query/Using-a-REST-API-as-a-data-source/td-p/50400) on how to get REST data in Power BI, but Power Query in Excel is virtually identical.