Forum Discussion
Web.Content Custom Connector Folding
where is the DateTime column that you are planning to use for the partition boundaries?
one of the table columns is a DateTime column (meaning: in any row there is ID, datetime, and more columns..)
therefore the partition and Incremental Refresh works great when the columns are the same for all rows.
the problem start only when I started to Expand the list key,value column into dynamic columns ..
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.