Forum Discussion

hgorina's avatar
hgorina
Frequent Visitor
10 years ago

connect to sharepoint folder or onedrive folder with subfolders

I am working with the data folder on a local drive.  The folder has one level of subfolders, and I am analyzing the files in these subfolders. Here is  how the query start looks.   I have pub...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
10 years ago

Hi hgorina,

 

To get all files in SharePoint folder, you can use SharePoint Folder data source type, and type root URL. Then you can get all files under this folder and it's related information. See:

 

 

Once you publish the report to Power BI, as the dataset is connecting to SharePoint site, the gateway is not required. You can configure the schedule refresh as daily frequency.

 

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu