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.
Forgive me, but I am a brand new user of Power BI. I am trying to create a report that sources a List from SharePoint Online. I made a successful connection, but all of the column names from the list were not maintained in the PBI table in desktop and instead were renamed as Field 1, Field 2, Field 3, etc. There must be a way to prevent this. But, my research so far has come up nill. I even watched some online tutorials that sourced a SharePoint Online list exactly the way I did and the column names remaned in tact in the PBI table.
Hi, @Kauffyman
I tested the connection from deaktop to SharePoint online list. The column name display is normal and failed to recover your problem.
https://docs.microsoft.com/power-bi/connect-data/desktop-sharepoint-online-list
Maybe you can try transform in the power query editor.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Well, unfortunately we will be doing a lot of these and I do not intend to have to transform the data manually for all of them when it should just work when I am doing everything exactly as prescribed in the article.
@Kauffyman Which connector did you use?
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 |