Forum Discussion
Solved
Power BI 'Show Tables' side panel
I've built a PowerApp and Power Automate solution to refresh tables using the enhanced refresh API. This all works well and I can retrive the the workspaces and datasets a user has access to to popul...
Hi mark_carlisle - I am sorry but think that Rest API can only excute DAX calls. The trying to run a SQL query against the DMV. It is possible to get this information using the Admin API. Announcing Scanner API (Admin REST APIs) enhancements to include dataset tables, columns, measures, DAX expressions, and mashup queries | Microsoft Power BI Blog | Microsoft Power BI
Hi mark_carlisle - I am sorry but think that Rest API can only excute DAX calls. The trying to run a SQL query against the DMV. It is possible to get this information using the Admin API. Announcing Scanner API (Admin REST APIs) enhancements to include dataset tables, columns, measures, DAX expressions, and mashup queries | Microsoft Power BI Blog | Microsoft Power BI