Forum Discussion
Load additional column values from a document library in SharePoint into Power BI.
I want to retrieve the values of additional columns added to a SharePoint document library as a data source in Power BI.
Specifically, I need to obtain the values of additional columns for multiple files located within a document library > folder > files structure.
When using the SharePoint List connector, I can retrieve column values from the document library, but I am unable to access the values inside folders.
On the other hand, the SharePoint Folder connector does not allow me to retrieve the values of additional columns.
I also tried using the Web connector based on GPT's suggestion, but it only retrieved continuous text in HTML format.
Is there any way to use the SharePoint List connector to retrieve information from a specific folder within the document library?
Additional Information:
The values of the AAA and BBB columns inside Sample > Folder from the images.
Hi LuckySun ,
Try the ODATA feed that can allow you to get the additional columns you need, check the questions below that talks about that.
3 Replies
Hi LuckySun ,
Try the ODATA feed that can allow you to get the additional columns you need, check the questions below that talks about that.
Hi LuckySun ,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information and description to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi LuckySun,
Any update on this? Did these suggest suitable for your requirement?
Regards,
Xiaoxin Sheng
