Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
1,837
Views
Topic starter
Pulling data from the web using an API token ... but the data isn't coming back in a columnar format (due to the advanced filter being used).
When I don't use a filter in the source, I get the results in the last screen shot of the attached.
How do I convert this query to get the same format as when no filter is being applied at the source?
FYI ... This is a "test" connection. The actual data that I will be using has 500k+ records that would come back if I don't use the filter in the source.
Thank you in advance for your help!!
Posted : 15/09/2021 10:39 am
Hi Stacey,
Add an index column before your unpivot step.
Mynda
Posted : 15/09/2021 10:23 pm