Using API to filter slicers and export summerized data into excel

TangoTango — Mon, 10 Apr 2023 21:05:10 GMT

I'm running into what appears to be a few limitations of the API. The main one is that exporting non-paginated reports don't support csv/excel. Is there no way to get the API to replicate the "Export Data -> Summerized Data" that a user can do from inside the report?

Next is make slice selections. I see I could create bookmarks and can select bookmarks through the api, so I at least have a workaround there even if slicers can't be directly set with the API.

My goal is to take 100+ slicer combinations and get the data for each one into a report to use in our data integrity and validation process.

Re: Using API to filter slicers and export summerized data into excel

v-jianboli-msft — Wed, 12 Apr 2023 03:10:54 GMT

Hi @TangoTango ,

It seems that the API you mentioned refers to the Power BI REST API.

The Power BI REST APIs provide service endpoints for embedding, administration, governance and user resources.

With Power BI REST APIs you can do the following:

Manage Power BI content
Perform admin operations
Embed Power BI Content

According to your description, Power BI embedded analytics Client API may helps you.

The Power BI Client API is a client side library that allows you to programmatically control your embedded Power BI content, by using JavaScript or TypeScript.

Use the client APIs to communicate between Power BI items (such as reports and dashboards) and the application code. This gives you the flexibility to build an end user experience according to your design.

Here are some report operations:

Export data from a visual in Power BI embedded analytics | Microsoft Learn

Use slicers when embedding a report in Power BI embedded analytics | Microsoft Learn

Best Regards,

Jianbo Li

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

topic Using API to filter slicers and export summerized data into excel in Developer

Using API to filter slicers and export summerized data into excel

Re: Using API to filter slicers and export summerized data into excel