More 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.
Powerbi Reports using SPN
Hi there, I'm trying to report on all workspace's, DataSets associated to a datasource in our tenant. We setup an spn with Tenant.Read.All delegated api permissions. The Allow service principals to use Power BI APIs is enabled for the security group that the app is a member of.Created a client secret as well as certificate.We are able to connect using Connect-PowerBIServiceAccount to 'however no data is returned. When connecting using my account, i'm able to output the workspace that my account is a member of. So i'm not sure if im missing other permissions to the workspaces.ReportingServicesTools Set-RsRestItemDataSource - BAD REQUEST how to diagnose?
I am attempting to write a script to update Datasource connect strings for power bi reports on PBIRS(on prem, no service) - Trying to add a port to the ( sharepoint ) url in the connect string. Forgive me as I am new to this and unsure how to move forward. Script is below and it does return the connectstring with the port to screen prior to setting it. Can anyone help with possible next steps or what might be wrong? Thanks in advance The last line Set-RsRestItemDataSource -RsItem $dataSourcePath -RsItemType 'PowerBIReport' -DataSources $ds -ReportPortalUri $ReportServerURI returns Failed to update data sources for '/AP/CSECR/Action%20Items': The remote server returned an error: (400) Bad Request. $ReportServerURI = "https://<svr>/Reports/" $ReportPortalUri = "https://<svr>//PBIReports" $dataSourcePath = "/MyReportPath" cls #Get-RsRestItemDataSource -RsItem $dataSourcePath -ReportPortalUri $ReportPortalUri $dataSources = Get-RsRestItemDataSource -RsItem $dataSourcePath -ReportPortalUri $ReportServerUri foreach($ds in $dataSources) { Write-Host $ds.ConnectionString $ds.ConnectionString = $ds.ConnectionString.Replace("mydomain.com", "mydomain.com.999") $ds.DataModelDataSource.AuthType = "Integrated" $ds.DataModelDataSource.Username = "Adomain\user" $ds.DataModelDataSource.Secret = "mypw" Write-Host $ds.ConnectionString Set-RsRestItemDataSource -RsItem $dataSourcePath -RsItemType 'PowerBIReport' -DataSources $ds -ReportPortalUri $ReportServerURI }
