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:
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
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!