Forum Discussion
Web.Content Custom Connector Folding
Hello, We have a connector that gets data from our server, and have RangeStart and RangeEnd and pagination support - All works great. But, one of the column in the data has value which is a li...
Add a fake row to each table that has all the columns you will ever see in the individual sources.
Or, do the right thing and unpivot your data.
I have specific request - I need to Expant a list into a flatten table columns. the pivot is the only way Power Query allows that. as far as I familiar with.
so I understand that the limitation is - that the first row of each page must be with values on all its columns.
ok
You don't need to have a pivoted result in Power Query. You can let the visuals do the pivoting for you.
but I want our customers to get out of the box (on Get Data) - a table with flatten columns, without list of object data. I don't want each customer to perform pivoting steps by themselves.