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.estorco55414 күн бұрын
Hey bud, nice video. Very helpful to me since I got new job and they are using dataflow. Many thanks!
@QtheDataLad14 күн бұрын
Glad it helped!
@optimumsportsnews93057 ай бұрын
Very helpful, thank you!
@QtheDataLad7 ай бұрын
You're welcome!
@jakeg97114 ай бұрын
What’s the benefit of using the data flow
@QtheDataLad4 ай бұрын
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
@DriekWorks7 ай бұрын
Hey, The copy URL is functional for OneDrive, why for SharePoint not use SharePoint Folder route?
@QtheDataLad7 ай бұрын
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