Forum Discussion
DataFlow to get excel file from Teams / Sharepoint
You need to choose web as the datasource
You can follow this, it says one drive, but will work with sharepoint
I have done the same using dataflows with Excel file residing in Teams files
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
Super UserYou need to choose web as the datasource
You can follow this, it says one drive, but will work with sharepoint
I have done the same using dataflows with Excel file residing in Teams files
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
thank you - I chose web API and it worked as expected. I wish the User Experience was cleaner - its all Microsoft so my expectations are higher!
Exactly what I needed to add my excel file to a dataflow. Thanks! Excited to see if i can track the changes over time as well.
