Import Pbix File as Service Principal

akarkal — Tue, 14 Dec 2021 21:48:33 GMT

I have the following settings going

- Tenant Developer Setting is enabled for Service Principal to access Admin APIs

- Service Principal is added as administrator to the workspace

- I am trying to upload a pbix to import as a report + dataset using the following

                    _ = await client
                        .Imports.PostImportWithFileAsync(
                            powerbiGroupId,
                            stream,
                            reportName,
                            ImportConflictHandlerMode.Overwrite,
                            skipReport: false);

- powerbiGroupId = workspace ID

- stream = stream from the file

- reportName = valid report name to be uploaded

I keep getting

System.Net.Http: The operation was canceled. System.Net.Http: 
Error while copying content to a stream. System.Net.Sockets: 
Unable to read data from the transport connection: 
The I/O operation has been aborted because of either a thread exit or an application request.. 
The I/O operation has been aborted because of either a thread exit or an application request.

The file is between 1MB - 1.4 MB. How do I check what the underlying issue is. Is there a limit that I am hitting ?

Re: Import Pbix File as Service Principal

Anonymous — Fri, 17 Dec 2021 06:25:50 GMT

Hi @akarkal ,

I check the limitation about Service principal. Service principal only support some read-only admin APIs. Post Import a pbix file to workspace needs Dataset.ReadWrite.All.

Here is the offical blog: Considerations and limitations

Service principal only supports some read-only admin APIs. To enable service principal support for read-only admin APIs, you have to enable the Power BI service admin settings in your tenant. For more information, see Enable service principal authentication for read-only admin APIs.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Import Pbix File as Service Principal in Developer

Import Pbix File as Service Principal

Re: Import Pbix File as Service Principal