Export data from Power BI server to SQL server

[ICBI]

Hello, I need som help figuring out how to accomplish the following.

I have a client that is running Power BI report server on premise who needs to export  a large number of rows(200 000+) from a Power BI report connected to an Analysis Services cube.

For Power BI Desktop and services this is possible using the methods described in the following article:

https://biinsight.com/exporting-power-bi-data-to-sql-server/

But these solutions won´t work for Power BI report server.

The functionality that I want to achieve for the end user is:

End user decides what slicers to use in the report and selects "Export"(Button/Textbox/hyperlink/something else).

I can capture the slicer selection as a measure using DAX but then I don´t know how to proceed from there?

So far I have two ways that might be possible with some magic 🙂

1. Insert distinct measure into a table in SQL server(How?) and use SSIS to query Analysis Services cube and export.
   
   
2. Pass distinct measure to SSRS report as parameter inside hyperlink(How?) and have the SSRS report run a procedure inserting the distinct measure into a SQL server table and then run SSIS to export.
   

I have searched for a solution but have not been able to find anything that fits what I need.

Any help on how to accomplish this would be greatly appreciated!

Thanks!

[philipplenz1]

You can use Paginated Reports with parameters. With this technology you can filter the data as same of PBI and export the data.

[Inquisitive]

Hi @ICBI , did you manage to find a solution.

Would you mind share it here as well. Cheers!