Forum Discussion

T91's avatar
T91
Frequent Visitor
1 year ago
Solved

Cannot import a report with live connections using service principal

I have a report and a semantic model in a workspace. I downloaded the report using API with DownloadType as 'LiveConnect'. When I try to import this report to another workspace using 'Post Import in ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi T91,

     

    Thank you for reaching out to the Microsoft Fabric Forum Community.

     

    If the issue still persists, I’d recommend raising a support ticket with Microsoft. The support team can look into the backend and provide more in-depth assistance tailored to your environment.

     

    https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

     

    Warm regards,
    Prasanna Kumar

     

Poojara_D12's avatar
Poojara_D12
Icon for Super User rankSuper User
1 year ago

Hi T91 

The ‘Not Found’ error when importing a report with a Service Principal happens because the SP doesn’t have enough permissions. Even if it’s a Contributor, it usually needs to be a Member or Admin in both workspaces and have access to the underlying dataset. Also, the Power BI tenant settings must allow the Service Principal to use the API. Your user account works because it has full access, but the SP’s access is more limited. To fix this, increase the SP’s workspace role, ensure tenant API permissions are enabled, and confirm the SP can access the dataset the report connects to.

 

T91's avatar
T91
Frequent Visitor
1 year ago

Thanks for the responses. But I still get 404 error.

 

I gave Service Principal 'Admin' role in both source and destination workspaces.

I can see that service principal has access in dataset's 'manage permissions' page.

Tenant settings allow the Service Principal to use the API