Forum Discussion
connect to excel file in share point folder as a dataflow
Hi again,
So first create your Dataflow (when you are in PBI premium workspace, click on New->Dataflow->Add New Tables ->Search for Sharepoint Folder).
Once you have your Dataflow open, follow this video:
Video is in PBI Desktop, but the same logic and steps are basically identical for the Dataflow.
Once you create connection to the datasource and you save it, go to the settings of Dataflow and set up credentials.
Refresh the dataflow and your data will be ready to use.
In case you want to see how to generally create Dataflow, check the link:
https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create
Thankyou Migasuke .
can you please let me know how to connect to share point as a source for the dataflow aswell.
Memorable MemberHi again,
So first create your Dataflow (when you are in PBI premium workspace, click on New->Dataflow->Add New Tables ->Search for Sharepoint Folder).
Once you have your Dataflow open, follow this video:
Video is in PBI Desktop, but the same logic and steps are basically identical for the Dataflow.
Once you create connection to the datasource and you save it, go to the settings of Dataflow and set up credentials.
Refresh the dataflow and your data will be ready to use.
In case you want to see how to generally create Dataflow, check the link:
https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create