Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ICBI
New Member

Export data from Power BI server to SQL server

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!

2 REPLIES 2
philipplenz1
Frequent Visitor

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

Inquisitive
New Member

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

Would you mind share it here as well. Cheers!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.