How to Connect SharePoint & Excel to Power BI

[@QtheDataLad]

Don't see the details option in sharepoint to get the file path? We can find it another way Step 1 - Hit the three dots on the excel file Step 2 - Open Excel file in App Step 3 - Click Info Step 4 - Click the button that says "copy path" Step 5 - Paste this path into data source in either powerbi desktop or powerbi service Step 6 - Remove "?web=1" from the end of the path in the data source box Step 7 - Close the Excel file in App

[@markkevinr.estorco554]

Hey bud, nice video. Very helpful to me since I got new job and they are using dataflow. Many thanks!

[@QtheDataLad]

Glad it helped!

[@optimumsportsnews9305]

Very helpful, thank you!

[@QtheDataLad]

You're welcome!

[@jakeg9711]

What’s the benefit of using the data flow

[@QtheDataLad]

dataflows are quicker for load and refresh times in service as well as in schematic models. dataflows are also good to share with other departments who want to use the same query/logic

[@DriekWorks]

Hey, The copy URL is functional for OneDrive, why for SharePoint not use SharePoint Folder route?

[@QtheDataLad]

you can go that route for sure. going this route is handy when you have multiple people editing within one centralized excel sheet. basically allows everyone on a team to make changes easily and that will flow to reporting