I am running a power query from a web source and after I convert to table then close and load, it only list 100 rows on the excel sheet. Can someone help with being able to not limit to 100 rows? I would like to pull in as many rows as possible.
I am running a power query from a web source and after I convert to table then close and load, it only list 100 rows on the excel sheet. Can someone help with being able to not limit to 100 rows? I would like to pull in as many rows as possible.
How on earth are we supposed to help debug your query, from a screenshot of the output, in a word document?!
Post your query code / attach your sample workbook.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks