Power BI REST API executeQuery Error when executing INFO function

[Lite]

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.

[GilbertQ]

Hi @Lite 

Can you try and run the DAX query view as shown below to make sure that it is returning the data you expect? You can now run this in the Power BI service as I have shown.

[DataVitalizer · Accepted solution]

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 💡

🟩 Follow me on LinkedIn