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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
julsr
Helper II
Helper II

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.