topic Re: Required code to remove the reports present in Power BI Embedded Workspace in Developer

Required code to remove the reports present in Power BI Embedded Workspace

Sunkari — Thu, 12 May 2016 07:20:30 GMT

Any body have code to remove the reports present in Power BI Embedded Workspace collection.

Please provide your inputs so that i will try implement functionality the code.

Re: Required code to remove the reports present in Power BI Embedded Workspace

Greg_Deckler — Thu, 12 May 2016 12:43:29 GMT

I do not see anything here that indicates you can programatically remove reports:

https://msdn.microsoft.com/en-us/library/mt711507.aspx

Unless removing a data set removes associated reports.

Re: Required code to remove the reports present in Power BI Embedded Workspace

Sunkari — Thu, 12 May 2016 14:10:04 GMT

Can you provide me information related to removing dataset?

Re: Required code to remove the reports present in Power BI Embedded Workspace

KirkNason — Fri, 13 May 2016 05:08:18 GMT

From the sample tool I used from this blog entry, a "dataset" is the .pbix files so it has the data & reports.

This is a great blog.

How to Embed Report in PowerBI Azure Service

http://www.mostafaelzoghbi.com/2016/04/power-bi-embedded-step-by-step.html

Source: https://github.com/Azure-Samples/power-bi-embedded-integrate-report-into-web-app/

https://github.com/melzoghbi/PowerBIEmbeddedSimplified

Re: Required code to remove the reports present in Power BI Embedded Workspace

Anonymous — Fri, 13 May 2016 07:48:33 GMT

You can delete a report by deleting the associated dataset.

I've managed to do this by adding the following code to Program.cs of the Sample app :

I added this code to the switch :

                    case '8':
                        if (string.IsNullOrWhiteSpace(workspaceCollectionName))
                        {
                            Console.Write("Workspace Collection Name:");
                            workspaceCollectionName = Console.ReadLine();
                            Console.WriteLine();
                        }

                        if (string.IsNullOrWhiteSpace(workspaceId))
                        {
                            Console.Write("Workspace ID:");
                            workspaceId = Console.ReadLine();
                            Console.WriteLine();
                        }

                        var datasets = displayDatasets(workspaceCollectionName, workspaceId);
                        
                        Console.WriteLine("Choose which dataset to delete :");
                        string datasetId = Console.ReadLine();
                        await DeletePbixFile(workspaceCollectionName, workspaceId, datasetId);
                        Console.ForegroundColor = ConsoleColor.Cyan;
                        Console.WriteLine("Report deleted successfully");

                        await Run();
                        break;

I created two methods that are called in the process :

The first one returns all the datasets (with their names and their ID) :

        static async Task<ODataResponseListDataset> displayDatasets(string workspaceCollectionName, string workspaceId)
        {
            // Create a dev token for deletion
            var devToken = PowerBIToken.CreateDevToken(workspaceCollectionName, workspaceId);
            using (var client = await CreateClient(devToken))
            {
                var datasets = client.Datasets.GetDatasets(workspaceCollectionName, workspaceId);
                foreach (Dataset set in datasets.Value)
                {
                    Console.WriteLine("Name : {0} : Id : {1}", set.Name, set.Id);
                }
                return datasets;
            }
        }

The second one deletes the dataset that has the ID that is passed as parameter :

        static async Task DeletePbixFile(string workspaceCollectionName, string workspaceId, string datasetId)
        {
            // Create a dev token for deletion
            var devToken = PowerBIToken.CreateDevToken(workspaceCollectionName, workspaceId);
            using (var client = await CreateClient(devToken))
            {
                    var deletion = client.Datasets.DeleteDatasetById(workspaceCollectionName, workspaceId, datasetId);
            }
        }

Simply press 8 when prompted for a choice by the console, and then copy and paste the dataset ID of the dataset you which to delete (along with the report that comes with it).

It does work on my side, but do not hesitate to ask questions if it doesn't on your side.

Cheers

Re: Required code to remove the reports present in Power BI Embedded Workspace

Sunkari — Fri, 13 May 2016 12:41:34 GMT

Thanks man. I will check and let you know.

Re: Required code to remove the reports present in Power BI Embedded Workspace

karthikeyan — Mon, 06 Jun 2016 06:06:33 GMT

Your article usefull for me. deleted the report file work fine but how to remove workspce ID?

thank you.

Re: Required code to remove the reports present in Power BI Embedded Workspace

Anonymous — Fri, 24 Jun 2016 12:56:18 GMT

@karthikeyan I don't know if removing a workspace is possible. I tried to remove one but I didn't manage to do so

Re: Required code to remove the reports present in Power BI Embedded Workspace

karthikeyan — Mon, 27 Jun 2016 04:06:20 GMT

@Anonymous Hi , thank you tired friend.

Re: Required code to remove the reports present in Power BI Embedded Workspace

Anonymous — Wed, 18 Apr 2018 08:53:29 GMT

You can right click on the report you want to remove and click on "Hide". That can be done only through the Power Bi desktop then you can re-publish.