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
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!