Load user defined properties of a SharePoint file folder into PowerBi

[Nikhil529]

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

[katika555 · Accepted solution]

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

[Nikhil529]

Below are the few properties i defined in sharepoint folder 

But I only get these defaults in Power Bi

[NikhilChenna]

Hi @Nikhil529 , 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]

Hi @Nikhil529 ,

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!