Can we get export from a visual of Power BI Report using API

[adeelnazirvrooz]

Dear Concern,

I'm new to Power BI. We are exploring Power BI in some scenarios. We are near going to use APP/User Owns data embedded solution (We will decide later.). because we are a product-based company and we will use one of these solutions.

Let me know my few concerns

1. Can we get export from a visual of Power BI Report using API
   
   1. Like if I have a table/matrix on a report's page and I want to schedule an export to file (Excel) all data and then want to send over emails? 
   2. How it would be possible. For any documentation, please refer here.
2. By considering the above scenario, Can an embedded user can get export of table/matrix for all data?
   1. If there any C# code required to do so, please refer to the documentation.
   2. If the code is the right solution then Is there any documentation available to do using python code?
3. By considering the above scenario, is exported data will be filtered based on Row Level Security applied?

I've gone through Power BI ExportToFile API, which is actually used to get export for a report, not visual data.

Please help,

Thanks

[v-lionel-msft · Accepted solution]

Hi @adeelnazirvrooz ,

The RLS feature is very powerful, so the user can only export the data he can view.

Best regards,
Lionel Chen

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

[v-lionel-msft]

Hi @adeelnazirvrooz ,

"1. Can we get export from a visual of Power BI Report using API?"

I didn't find such a Rest API .

Maybe you can try to export data using Python/R.

"2. By considering the above scenario, Can an embedded user can get export of table/matrix for all data?"

" 3. By considering the above scenario, is exported data will be filtered based on Row Level Security applied?"

Please refer to this.

Customize the export data user experience 

Best regards,
Lionel Chen

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

[adeelnazirvrooz]

" 3. By considering the above scenario, is exported data will be filtered based on Row Level Security applied?"

In my case power, bi reports are embedded using the app's owns data technique. So It means RLS will be applied on export. but again I'll confirm and update you guys.

[lbendlin]

1. currently only possible as PDF, PPT or PNG for the entire report or entire page , not for individual visuals