Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Nikhil529 When choose SharePoint data type, choose as SharePoint List its get all attributes of folder, columns atc.
@Nikhil529 When choose SharePoint data type, choose as SharePoint List its get all attributes of folder, columns atc.
Below are the few properties i defined in sharepoint folder
But I only get these defaults in Power Bi
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!
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |