Latest Enterprise DNA Initiatives

Get correct titles from Sharepoint


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

Bumping this post for more visibility.

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.

Ankit J

Hello @supergallagher25

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

Kumail Raza

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.