Sharepoint connect to a folder - not bringing in all columns

[CollabTechie]

Hi Community,

I have been able to successfully connect to the root of my document library by modifying the query from Sharepoint.files to Sharepoint.contents. However, I need to bring in additional columns that I have created to reported on document ratings for example.

The query doesn't seem to bring these in. Any ideas on how I might be able to get these into my table?

Thanks,
Mark

[v-diye-msft · Accepted solution]

Hi @CollabTechie 

Please kindly note that:

1. When connecting to a Sharepoint Online List, the data will be pulled in under the original field title. So, if you retitle one of your columns in the Sharepoint list be aware that the name will not change in the data set. (Unless you change it in the Query Editor)

2. Not all data types will appear under their exact column title

3. Powerbi was pulling the original name. SP list keeps the internal name of column, no matter how many column display name editied. So needed to delete old column and create new to change internal name on that list.