Forum Discussion
Solved
Frustrating Power Query Editor and Sharepoint Lists
I've spent days on this when I feel it should be pretty straight foward. I have various SharePoint lists.. some columns are type lookup, and I'm trying to transform the lists. I have a very simp...
Hi tknguyen
If the issue still persists we recommend you to raise support ticket.https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
If this solution helps, please consider giving us Kudos and accepting it as the solution so it can assist other community members.
Thank you.
Hi tknguyen - can you add a custom column with below formula
= Record.Field([ReleaseType], "Title")
after that, Name the new column appropriately. This works because you’re directly telling Power BI: “I know there’s a field called Title in that record—just get it.”
Please check and let know.
Thank you for the quick response, but I get this error:
Here is the sharepoint list it's looking up: