Forum Discussion
REST API query snowflake datasource connectionDetails
- 4 years ago
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-authentication-to-make-for-better-tenant-metadata-scanning/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,
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-authentication-to-make-for-better-tenant-metadata-scanning/
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,
Very helpful, thanks!