cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Rest API Export Report to PDF that uses Azure Analysis Service as a data set

Hi;

I'm using the Rest API Call : POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/ExportTo.

 

I can successfully export a pdf report if the data is stored in PowerBI.

 

When I try to export a report to PDF that uses Analysis Service as it's Data Source
I then get the following Error : Export report requires effective identity to be provided for the report's data set.

 

What I have set up :
1. Premier Workspace where the PowerBI report is published
2. Followed the instructions to create a service principal and add it to power bi : https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-service-principal
3. The Service Principal has been added to the Azure Analysis Service Server as an Administrator
4. The Service Principal has been added to the Azure Analysis Service Database to a Role that has admin rights
5. Generate a Oauth Token :

grant_type:client_credentials
client_id: {My Client ID Generated in step 1}
client_secret:{Client Secret Generated in Step 1}
scope:openid
resource:https://analysis.windows.net/powerbi/api

6. Use the token received to call the Rest API Post Action : https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/ExportTo


Is there something else that needs to be done in order to allow the generation of the pdf when the data set is from a analysis service database ?

 

Thanks in Advance

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: Rest API Export Report to PDF that uses Azure Analysis Service as a data set

Hi;

 

 

    Just an update on the solution.

    It seems to pass the effective identity one needs to add the following into the body :

   

{

    "format": "pdf",

    "powerBIReportConfiguration": {

        "identities": [

            {

                "username": "{ ServicePrincipal Object ID }",

                "roles": [

                    "{Role in AAS}"

                ],

                "datasets": [

                    "{datasetID}"

                ]

            }

        ]

    }

}

 

*Just also note as per the MS documentation that one needs to pass in the Service Principal object id and not the service ServicePrincipal app id

View solution in original post

1 REPLY 1
Highlighted
Frequent Visitor

Re: Rest API Export Report to PDF that uses Azure Analysis Service as a data set

Hi;

 

 

    Just an update on the solution.

    It seems to pass the effective identity one needs to add the following into the body :

   

{

    "format": "pdf",

    "powerBIReportConfiguration": {

        "identities": [

            {

                "username": "{ ServicePrincipal Object ID }",

                "roles": [

                    "{Role in AAS}"

                ],

                "datasets": [

                    "{datasetID}"

                ]

            }

        ]

    }

}

 

*Just also note as per the MS documentation that one needs to pass in the Service Principal object id and not the service ServicePrincipal app id

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.