The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
123 | |
111 | |
78 | |
74 |