Forum Discussion
Power BI REST API executeQuery Error when executing INFO function
hi,
I am trying retrieve Power BI table metadata using INFO.COLUMNS() function.
it works fine when I execute the "EVALUATE INFO.COLUMNS()" syntax on DAX Studio. But when I tried to run this syntax in REST API and Power Automate, it keep failing and throwing an error 3239575574.
any idea what to check? Thanks.
Hi Lite
INFO.COLUMNS() works in DAX Studio because it runs directly against the XMLA endpoint, but it isn’t supported through the REST API or Power Automate and that’s why you get error 3239575574, so If you need metadata in flows, use the REST endpoints for tables/columns, or connect via XMLA instead.Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡
2 Replies
Hi Lite
INFO.COLUMNS() works in DAX Studio because it runs directly against the XMLA endpoint, but it isn’t supported through the REST API or Power Automate and that’s why you get error 3239575574, so If you need metadata in flows, use the REST endpoints for tables/columns, or connect via XMLA instead.Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡
