cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ICBI New Member
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!

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!