SharePoint + Excel + Power BI - Make the Trio Work

Connect an excel file that is stored in SharePoint into Power BI desktop or through a dataflow. See highlighted comment if you don't see the details option in SharePoint.

0:00 - some guy from the internet doing a lazy intro
0:21 - upload excel file to sharepoint and grab excel file path
1:02 - put file path in power bi file using web data source
2:27 - upload excel file from sharepoint to dataflow in power bi service
3:14 - me needing to be rebooted to speak english
3:26 - loading table in powerbi service & creating a custom column
5:20 - bring dataflow into power bi file
6:56 - save the power bi file/outro

if this helped, like or subscribe or ill eat ur cookies:    / @qthedatalad  

email: [email protected]

#sharepoint #powerbi #powerbitraining