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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
julsr
Resolver I
Resolver I

Download reports as excel files from huge datasets

Hello Everyone,

 

I have multiple datasets in my database. I want to enable my business users to download the results of some stored Procedures through PowerBI once they select some filters and the report is updated as they wish. I was thinking of doing the following:

  • Use a Stored Procedure to bring the whole dataset into PowerBI as a PBI Dataset
  • Connect the Reports to these datasets
  • Create filters inside the reports that use these datasets as source
  • make the main visuals and tables in the report to use data from the dataset

The stored procedure could be updated daily using incremental refresh (https://www.youtube.com/watch?v=-KXDpi_wyD4&t=29s), so all data would be on the server and easily available.

 

Is there any recommendation about doing this? What other way could I achieve this?

 

Thanks,

 

1 ACCEPTED SOLUTION
v-huijiey-msft
Community Support
Community Support

Hi @julsr ,

 

The idea of using stored procedures to bring data sets into Power BI makes sense.

 

To get started, the following prerequisites must be met:

 

A tenant account with an active subscription. Create an account for free.

 

A workspace is created.

 

For more details on using stored procedures, please see:

How to use the Stored procedure activity - Microsoft Fabric | Microsoft Learn

 

Before publishing to a Power BI service, ensure that the incremental refresh policy is properly configured in Power BI Desktop.

 

For more details about using incremental refresh, please see:

Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

 

Here is a guide on how to add and configure filters in reports:

Filters and highlighting in Power BI reports - Power BI | Microsoft Learn

 

Download the report from the huge dataset as an excel file, you can refer to the video below to get it:

Explore Europe with Finnair (youtube.com)

vhuijieymsft_0-1713837446080.png

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

View solution in original post

1 REPLY 1
v-huijiey-msft
Community Support
Community Support

Hi @julsr ,

 

The idea of using stored procedures to bring data sets into Power BI makes sense.

 

To get started, the following prerequisites must be met:

 

A tenant account with an active subscription. Create an account for free.

 

A workspace is created.

 

For more details on using stored procedures, please see:

How to use the Stored procedure activity - Microsoft Fabric | Microsoft Learn

 

Before publishing to a Power BI service, ensure that the incremental refresh policy is properly configured in Power BI Desktop.

 

For more details about using incremental refresh, please see:

Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

 

Here is a guide on how to add and configure filters in reports:

Filters and highlighting in Power BI reports - Power BI | Microsoft Learn

 

Download the report from the huge dataset as an excel file, you can refer to the video below to get it:

Explore Europe with Finnair (youtube.com)

vhuijieymsft_0-1713837446080.png

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.