Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Exporting PBI report to pdf file via REST API - cannot load model

Hello, 

 

I'm trying to export pbi report to pdf file using REST API 😞https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/ExportTo) and so forth.

and I successfully can when the report has no RLS defined on it.

If it does then the pdf file generated contains error message, such as:

"Cannot load model", etc., please view attachment below.

 

 

This is the body format that I'm sending with my request when trying to export a report with no RLS:

$body = '{ format : "pdf" }'

 

But when a report with RLS is sent to be exported then I need to append identity within the body, otherwise it would complain that no identity was specified.

 

$body = '{
format : "pdf",
powerBIReportConfiguration : {
identities : [{ username : "[email protected]", roles: [ "role" ], datasets : [ "a5f0xxx--yyy-zzz-zzzf1da6916" ] }]
}
}'

 

I've tried multiple users, all of them having assigned the role and all of them capable of viewing the PBI report itself including data when accessing it via PBI Service.

 

Any ideas, please, what should be set for this to work?

 

Thank you.

 

Marcel

  • Hi, Anonymous 

     

    I need to check with you if the report can be displayed properly inside the service. Also is RLS properly configured in the service (dateset-security-role)?

     

    This is the relevant document, hope to help you:

    https://community.powerbi.com/t5/Service/Export-API-with-dynamic-RLS/m-p/2071903 

     

    Best Regards,

    Community Support Team _Charlotte

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

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi, 

     

    the issue has been resolved by specifying correct role name that would match the one specified in PowerBI Service Row-Level Security tab, please, see below.

     

    Thank you very much.

     

    Marcel

     

3 Replies

  • v-zhangti's avatar
    v-zhangti
    Community Support

    Hi, Anonymous 

     

    When you have RLS configured you would need to create an Admin role or a role without any restrictions to allow certain users to see all the data. Maybe you can try exporting the PDF with a role that allows to see all the data.

     

    If I have misunderstood, please feel free to communicate.

     

    Best Regards,

    Community Support Team _Charlotte

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

  • v-zhangti's avatar
    v-zhangti
    Community Support

    Hi, Anonymous 

     

    I need to check with you if the report can be displayed properly inside the service. Also is RLS properly configured in the service (dateset-security-role)?

     

    This is the relevant document, hope to help you:

    https://community.powerbi.com/t5/Service/Export-API-with-dynamic-RLS/m-p/2071903 

     

    Best Regards,

    Community Support Team _Charlotte

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, 

     

    the issue has been resolved by specifying correct role name that would match the one specified in PowerBI Service Row-Level Security tab, please, see below.

     

    Thank you very much.

     

    Marcel