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 straight up vanilla text field in my SPO list that I'm trying to import its called "DisplayName" there is no evidence of it in power query at all. Its not a calculated column or anything it just holds text. All I can think of is that its using a column name that PowerBI is not able to use?
Ideally I don't want to rename it (Powerapps code will need changing) but I guess if I am forced to I will.
Edit; some screenshots for clarity, the column 'DisplayName' does not apear
Edit 2 - I re-checked the list column name in SharePoint and it is named correctly, reloaded in Powerquery but it cannot find it. I noticed M query handles the ID naming - ID.1
Are you certain that you did not create the column as one name and then rename it? SharePoint tends to keep the original column name and simply masks this with a "display name" while under the hood it still references the original name the column was created as. If you could post the full list of SharePoint columns in that list, we might be able to get there through process of elimination.
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
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 |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |