🚀 In this video, we are looking at a common scenario for many companies – importing multiple files from a SharePoint folder to build reports in Power BI. This is an effective solution for businesses that do not have a large-scale database system yet or companies that are in transition and in need of immediate reporting.
📊 What you'll learn:
- Connect to a SharePoint folder using Power BI Desktop.
- Combine multiple files using PowerQuery.
- Ensure the simplicity of refreshing a Power BI report when new data is added.
⏱️ Timestamps:
00:00 - Introduction
00:19 - SharePoint scenario description
02:24 - Connect to a SharePoint folder
04:22 - Combine multiple Excel files using PowerQuery
10:58 - Update report with new data from SharePoint
🔗 Useful links:
Sample files used: https://shorturl.at/ruzIY
About SharePoint Folder in Power BI: https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder
🤝 Let's Connect:
LinkedIn: https://www.linkedin.com/company/centida/
Website: https://centida.com/
If you need support with implementing Microsoft Fabric or Power BI, please reach out to us. We’re here to provide both business and technical expertise.
Centida GmbH
34 Kernenhofstrasse, Oberkirch
77704, Germany
Email:
[email protected]
#PowerBI #PowerQuery #SharePoint
👍 If you found this video helpful, please give it a thumbs up, and consider subscribing to stay updated with our series. Your engagement helps us create more valuable content for the community.