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,
And it gives me the following error