How to disable excel export of certain paginated report?

[fareed221]

Hello,

I am trying to disable the export to excel functionality of certain paginated reports. I know that we can disable the excel export option from admin tenant settings but in that case that will disable all the Power BI Reports and Paginated Reports. I have a use case where I want to disable the excel export functionality for certain paginated reports. Is there a way to achieve this? 

Please let me know.

Thanks.

[fareed221]

Can you let me know where is that "on/off" option in the report builder?

[collinq · Accepted solution]

HI @fareed221 ,

In the Admin Portal, there is only an "on/off" type option.  However, in the Report Builder, for the report itself there is a "on/off" option.  But, I think that it is only on/off and not a "can't use Excel to export" option.  

[collinq]

Hey @fareed221 ,

My second sentence missed a critical work there is "NOT" a way I know of in Report Builder itself to turn it on or off.  However, you can do this to remove the capability:

Removing a Rendering Extension - SQL Server Reporting Services (SSRS) | Microsoft Docs