Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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:
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,
Solved! Go to Solution.
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)
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!
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)
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!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |