REST API query snowflake datasource connectionDetails

[Anonymous]

Hi all,

Currently using Power BI REST API to query datasources and get connection details. datasource.connectionDetails is currently returning the snowflake server and the warehouse being used.

Does anybody know if it is possible to get data on the actual view/table names? This information appears in the M for the connection in Power BI Desktop so was hoping it was also available from the REST API?

[ibarrau · Accepted solution]

I think the only way to reach the schema of the data model is with the scanner api. Building a script with 4 requests that will show dataset and the tables/columns. You can read more about it here:
https://powerbi.microsoft.com/en-us/blog/announcing-new-admin-apis-and-service-principal-authenticat...

Otherwise you can't reach tables structure. If you where asking about getting the data and you know the structure, you might want to check "ExecuteQueries" under dataset requests of the Power Bi Rest API doc.

I hope that helps,

[Anonymous]

Very helpful, thanks!