Forum Discussion
Solved
DataFlow to get excel file from Teams / Sharepoint
I got this to work as a Dataset - however not very useful as I need a report with different data sources. These are the steps I've tried to get the DataFlow to work: New DataFlow Choose Excel ...
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
blopez11
Super User
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
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.