Forum Discussion
Helper IIIHow to get all columns in the SharePoint Document Library
We are adding a column to the SharePoint Document Library ("DocLib A") and entering a value.
However, when I try to retrieve the SharePoint Document Library with Power BI (Query Editor), the columns that I should have added are not displayed.
The connector we are using is a "SharePoint Folder".
For example, if you add columns A and B to DocLib A, columns A and B will not be loaded into Power BI.
Only the following columns will be loaded into Power BI.
・Content
・Name
・Extension
・Data accessed
・Data modified
・Data created
・attributes
・Folder Path
What is the best way to get ColumnA and ColumnB?
If there is a better way to do this, could you please let me know?
Best regards,
Lopez
3 Replies
- amitchandak
Super User
Lopez0090Thank you very much.
I was able to get all the columns using the SharePoint online list connector.
I have the same problem, but it does not work for me. I have extended a Sharepoint document library with some columns. When I connect the list to PowerBi via Sharepoint List, I only see the columns I added but not the library information (like folder names). When I connect to PowerBi via Sharepoint.folder I don't see my added columns. Since there doesn't seem to be a common ID between the two queries, I can't combine the queries either. Does anyone have a working solution for this?
