Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Community,
I have some different requirement from Customer in relation to reporting (Snap shot in time ) . As of now,There are some SQL queries we have been running every day (Weekdays) and store the results in an excel spreadsheet . This Spreadsheet is placed in Sharepoint and then connected to Power BI for reporting through Get Data --> Share Point folder option. To follow this process everyday, some times it is getting hectic for us to do this entire process manually.
So, I would like to know if there is any automated solution that can be implemented to avoid manual effort . The available tools i have are as shown below :
- SQL Server Management studio
- SSRS/SSIS/SSAS
- Power BI
Please assist !!!!!
Thanks,
G Venkatesh
@Anonymous , you should explore incremental load
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
Power Automate
Hi @Anonymous ,
Based on your description, you use SharePoint to export and save historical data every day. See if this blog can help you:https://visualbi.com/blogs/microsoft/powerbi/historical-data-preservation-using-power-bi-dataflow/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
90 | |
85 | |
66 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
82 | |
71 |