The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello All,
The company I work for has multiple ways of storing data (dont ask me why lol).
I have to create a automated report with three different documents. 2 Excel files (SQL server are required to use as they are automated reports) and one Smartsheet. Now i was reading up on how to blend documents together and know its possible to transform two excels, blend them together and just delete and add what is needed.
My Question is, Can I blend Excel and Smartsheet together to have an Automated report? Will it work if I transform all the files in to one and remove the columns not required and add in the additional forumulas required to mimic a report that is manually done at the moment.
If you need more information / details, please let me know.
Please and Thank you!
Best,
Daniel
Solved! Go to Solution.
Hi, @Dklein
You can blend Excel and Smartsheet data to create automated reports.
The Smartsheet Live Data Connector tool allows you to link Smartsheet data with Excel. It enables you to extract data from Smartsheet into Excel for further analysis and reporting.
Microsoft Excel | Smartsheet
Use Power Query in Excel to transform and merge data from multiple sources, including Excel files and Smartsheets. You can clean, filter, and merge data as needed. You can check the following Link:
coefficient.io
If you need to automate the export of data from Smartsheet to Excel, Smartsheet's Data Shuttle can help. It allows you to schedule periodic data transfers from Smartsheet to Excel
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Dklein
You can blend Excel and Smartsheet data to create automated reports.
The Smartsheet Live Data Connector tool allows you to link Smartsheet data with Excel. It enables you to extract data from Smartsheet into Excel for further analysis and reporting.
Microsoft Excel | Smartsheet
Use Power Query in Excel to transform and merge data from multiple sources, including Excel files and Smartsheets. You can clean, filter, and merge data as needed. You can check the following Link:
coefficient.io
If you need to automate the export of data from Smartsheet to Excel, Smartsheet's Data Shuttle can help. It allows you to schedule periodic data transfers from Smartsheet to Excel
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
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 August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.