Import Pbix File as Service Principal

[akarkal]

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 ?

[Anonymous · Accepted solution]

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.