Why are most of my sharepoint online documet library columns not showing?

[mcdryburn]

I'm trying to build a basic BI report with a sharepoint online document library as the source.  When i select get data and Sharepoint Folder and paste the root URL to my SP site it only pulls through some standard columns and not the additional metadata columns I added to the SP doc library.  Is there a way for BI to read and include these columns in the report?

Thanks  

[christinepayton]

The SP Folder connector is more for extracting content from inside files in a folder, not for getting metadata about the files. For metadata about the files, you can use the OData connector. Here's a tutorial for using the OData connector with SharePoint libraries: https://youtu.be/yeIQ9jKln_I?si=n7eoKeaoPM2xWOTa