Get correct titles from Sharepoint

Power Query
1

Hello,

I have a table in sharepoint that has over 50 columns and some of them are nested. When I link it to PowerBI, I end up getting the internal column names. I was able to extract the external column names following this guide

However, it arrives in an unpivot format. And I can’t really pivot the columns on the actual table since there are nested columns inside.

I have tried to create a list out of the query that I had created using the PowerBI link and then insert it as a step into the other table by using the following statement,

Table.RenameColumns(#“Changed Type”,#“Headers”,MissingField.Ignore)

And it gives me the following error

image
image788×347 89.5 KB

2

Bumping this post for more visibility.

3

Hi @supergallagher25

Can you please share the sample list structure you have and the Output that is required in a spreadsheet or table. Also, the issue that you are facing.

Once provided with this information, we will be able to help you.

Thanks
Ankit J

4

Hello @supergallagher25

If you could provide sample .pbix file that should be great.

Regards
Kumail Raza

5

Hi @supergallagher25, we’ve noticed that no response has been received from you since the 8th of June.

We are waiting for the masked demo pbix file and any other supporting links and details.

In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.