Forum Discussion

Lite's avatar
Lite
Frequent Visitor
9 months ago
Solved

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...
Need Help
  • DataVitalizer's avatar
    DataVitalizer
    9 months ago

    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

DataVitalizer's avatar
DataVitalizer
Super User
9 months ago

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