GetReportsInGroupAsync returns duplicate report names with different report ids

MattStannett — Wed, 20 Mar 2019 23:24:38 GMT

These duplicate reports with different ids do not appear under the available reports in the portal...

My code:

public async Task<IList<Report>> GetAvailableReportsAsync()
		{
			AzureToken azureToken = await _authenticationHandler.GetAzureTokenDataAsync();

			using (PowerBIClient client = new PowerBIClient(new Uri(_powerBiSettings.ApiUrl), azureToken.TokenCredentials))
			{
				ODataResponseListReport reportsResponse = await client.Reports.GetReportsInGroupAsync(_powerBiSettings.WorkspaceId);

				return reportsResponse.Value;
			}
		}

List of reports I get back along with their ids:

Pilot V1: FA0FBC1E-45C3-41DC-A1B9-137504828902
Pilot V1 - CSV Demo Report Only Test RLS: 855E68A4-BEC6-4653-869F-BF1E8162A681
Pilot V1: B3FB2146-AB9B-45B5-9359-AABCC06288C5
Pilot V1 - CSV Demo Report Only Test RLS: F7C93238-7CAC-4185-B9A6-2B8BCEA5E6CC
Full Report Suite Report Only: D67DE714-700D-4398-8AAA-4941D3716CDC
Full Report Suite Report Only: 9CC54008-5883-4790-AF99-8069FF67642E

Re: GetReportsInGroupAsync returns duplicate report names with different report ids

MattStannett — Sun, 24 Mar 2019 19:14:55 GMT

Turns out this was because the reports had been deleted then recreated with the same name, PowerBI keeps the report names around somehow but assigned them a different GUID. Interestingly running the duplicated report returned the same name so the link to the dataset must be there..

topic Re: GetReportsInGroupAsync returns duplicate report names with different report ids in Developer

GetReportsInGroupAsync returns duplicate report names with different report ids

Re: GetReportsInGroupAsync returns duplicate report names with different report ids