Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
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!
You can use Paginated Reports with parameters. With this technology you can filter the data as same of PBI and export the data.
Hi @ICBI , did you manage to find a solution.
Would you mind share it here as well. Cheers!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
5 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
7 | |
3 | |
3 |