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.
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
Solved! Go to Solution.
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.
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.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |