Forum Discussion

LiranRom's avatar
LiranRom
Icon for Helper I rankHelper I
2 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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.

LiranRom's avatar
LiranRom
Icon for Helper I rankHelper I
2 years ago

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