Power BI 'Show Tables' side panel

[mark_carlisle]

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 populate drop down lists within the PowerApp. However the user is required to type the names of the tables they would like to refresh.

I've noticed on the details page of a dataset theres a Tables view panel, is there anyway to access this data via an API request?

[Daryl-Lynch-Bzy · Accepted solution]

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, ...

[Daryl-Lynch-Bzy]

Hi @mark_carlisle - Yes 

Using the Power BI Rest API Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Learn

There is also a Power Automate connector - Announcing general availability of the ExecuteQueries REST API | Microsoft Power BI Blog | Microsoft...

[mark_carlisle]

Could you expand on that?

Tried the following Flow...

But got this response..

{"statusCode":200,"headers":{"Pragma":"no-cache","Transfer-Encoding":"chunked","Strict-Transport-Security":"max-age=31536000; includeSubDomains","X-Frame-Options":"deny","X-Content-Type-Options":"nosniff","RequestId":"6a78a184-b829-4804-af11-5d20a9563042","Access-Control-Expose-Headers":"RequestId","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"false","x-ms-apihub-obo":"false","Cache-Control":"no-store, must-revalidate, no-cache","Date":"Mon, 16 Jan 2023 08:10:02 GMT","Content-Type":"application/json","Content-Length":"149"},"body":{"results":[{"error":{"code":"DataExtensionError","message":null,"details":[{"code":"AnalysisServicesErrorCode","detail":{"type":"1","value":0}}]}}]}}