Тёмный
No video :(

Combine Data from Multiple SharePoint Files with Power BI 

Essential Excel
Подписаться 21 тыс.
Просмотров 13 тыс.
50% 1

Need to combine data from multiple SharePoint files with Power BI?
In previous tutorials we looked at gathering and storing data to our SharePoint document library, in this tutorial we demonstrate how we can combine the data from each of our files and report upon that data within Power BI. This tutorial covers how to connect to a SharePoint library, importing CSV files from SharePoint and how to combine data from multiple files.
PREVIOUS TUTORIALS
If you want to see how we created our source files in previous videos:
• Power Automate
WHAT IS POWER BI?
Power BI is a business intelligence tool provided by Microsoft for analysing and visualizing data providing both you and your customers with more meaning insights. If you are familiar with using Microsoft Excel then Power BI is the progression you need to take your reporting to the next level.
Get started today by downloading the application for free:
powerbi.micros...
If you enjoyed this tutorial do not forget to give the video a like and subscribe from more content!
Have a question? Please drop me a comment below and I will respond as soon as possible.
MORE TUTORIALS
/ essentialexcel
#sharepoint #powerbi #tutorial

Опубликовано:

 

5 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 14   
@EssentialExcel
@EssentialExcel 2 года назад
I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content! For More 👉 ru-vid.com
@WarezRocker
@WarezRocker Год назад
May i know how can i combine mutiple file for .xlsx format? I followed your tutorial, works fine for .csv, but not working for .xlsx Any tips please?
@katchupation
@katchupation Год назад
Thank you for this wonderful tutorial
@EssentialExcel
@EssentialExcel Год назад
Thank you! 🙂
@lorax4732
@lorax4732 Год назад
Wondering if it's possible to do that but only to data that lives in a specific sheet from that file
@vaibhavwankhede7095
@vaibhavwankhede7095 Год назад
Regarding share point data which is load into power BI, While loading, it should not be duplicate data shows And while updating like update rows or adding new column or updating any data shows updated data same as SCD 2 Please do this video based on this scenario
@ahv5457
@ahv5457 Год назад
Once you have all the binary contents, rather than combining them all, I 'd like to crate separate tables for each binary because in my SharePoint folder I have different tables. How to do that please?
@user-mj7wy4rp2d
@user-mj7wy4rp2d 10 месяцев назад
I get "DataSource Error: SharePoint:Request failed: The remote server returned an error: (500) " in the last row after filtering files . I cannot perform any step after this point as I keep on getting same error. Please help.
@michealburton8558
@michealburton8558 Год назад
i thought this was going to be the missing key to my problems but i get this error message DataFormat.Error: The input couldn't be recognized as a valid Excel document. Details: [Binary] can you help please?
@EssentialExcel
@EssentialExcel Год назад
Hi Michael. Do you receive the error when initially trying to import your excel document?
@michealburton8558
@michealburton8558 Год назад
@@EssentialExcel yes
@KellseaGeers
@KellseaGeers Год назад
@@EssentialExcel I am getting this error as well, is it because I am combining xlsx instead of a csv? If so is there a work around using xlsx?
@beasupgen
@beasupgen Год назад
@@EssentialExcel I'm interested too. Please any solution for excel?
@beasupgen
@beasupgen Год назад
found it, so simple! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QBE9IXMstqM.html
Далее
Throwing Swords From My Blue Cybertruck
00:32
Просмотров 11 млн
Combine SharePoint Lists Data Using Power BI
6:24
Просмотров 16 тыс.
Microsoft Lists integration with Power BI
8:30
Просмотров 74 тыс.