lakehouse files
1 TopicMore Granular when pulling Semantic Models from Rest API
I am trying to pull all the tables inside my lakehouse using PowerBI's Rest API. Originally, I used: Reports - Get Reports In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn then created a loop to pull all datasources of reports using the datasetID: Datasets - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn However, I notice when it is a semantic model it just shows as a SQL and does not provide the tables. Additionally, It only pulls the sources of reports. I want all the data inside a workspace. Is there a way to the next granular level, so I may see if we are duplicating pulls of tables. Also, is there a way to tell if a table is a shortcut or another re-pull of the same datasource? I am going to test this pull: Admin - WorkspaceInfo GetScanResult - REST API (Power BI Power BI REST APIs) | Microsoft Learn to see if I can get tables.717Views0likes1Comment