I have a SharePoint file folder where we store various user defined properties for each file. I need that property values in PowerBi to generate a Bar Chart but currently it only pulls Size, Content Type and Kind attributes of each file. I need a way to pull other properties which I defined other than these defaults

Anonymous When choose SharePoint data type, choose as SharePoint List its get all attributes of folder, columns atc.

Load user defined properties of a SharePoint file folder into PowerBi

NikhilChenna
Skilled Sharer
3 years ago
Hi Anonymous , Can you show us the sample data set and what is the expected outcome of it.

Regards,
Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
- NikhilChenna
  Skilled Sharer
  3 years ago
  Hi Anonymous ,
  I think intially when you pulled the data from sharepoint folder you had only this 3 columns and the data came perfectly. and if you have added some more columns in your data and now you want to see that columns then you have to follow the below steps.
  
  1. Go the power query editor.
  2. Go to the helper queries and click on the Transform File of that query as shown in the below image,
  3. In the middle query portion you can see there is a code and in that you can see there is a line
  columns=21 in your case it can be columns=3 then you can increase that number according to the columns in your file.
  
  hope this helps you.
  
  Regards,
  Nikhil Chenna
  
  Appreciate with a Kudos!! (Click the Thumbs Up Button)
  Did I answer your question? Mark my post as a solution!
Anonymous
Not applicable
3 years ago
Below are the few properties i defined in sharepoint folder
But I only get these defaults in Power Bi
katika555
Resolver I
3 years ago
Anonymous When choose SharePoint data type, choose as SharePoint List its get all attributes of folder, columns atc.