Using fetchMoreData/dataReduction for pagination
So, I got a request from my employer to paginate the data tables, but also with a bunch of strange formatting that they like which makes it somewhere between a table and a matrix. That stuff is no big deal, the problem I am running into is the pagination. I wanted to use the fetchMoreData/dataReduction feature to get a window (the size of the page of data) but I can't for the life of me figure out (might be due to lack to sleep at this point) how to get the onclick event of a link to trigger the fetchmoredata and also that method doesn't seem to have an option for fetch previous data so I can get away from loading the whole data set into memory when it isn't needed. Only the current page of data is needed and while I could load that page and then once the visual is rendered load each subsquent page's data and keep it in memory (bleh so wasteful). Can I use a javascript function to tell my visual what the current page number should be so I can index in and out of that dataview? It is just html but I would assume I need to make a server round trip for that extra data.
new page when data changes in data
i'm looking to turn data like this: site schoolYear student course grade Site A 2023-2024 Student A Math A Site A 2023-2025 Student A Science B Site A 2023-2026 Student A History A Site B 2023-2024 Student B Geography C Site B 2023-2025 Student B Gym A Site B 2023-2026 Student B Health A into 2 separate pages like this: i need to setup the page break when the student changes from Student A to Student B how do i do this using Power BI Report Builder?
PowerQuery for Slack
Hello, For the life of me, I can't figure out why this doesn't work. I'm trying to get a list of all users of a Workspace, with pagination. I can't seem to get the if statement to work to build the URL to deal with paging. Maybe my approach is wrong, I don't know. Advice? let vUrl = "https://slack.com/api/admin.users.list?team_id=12&limit=2", vHeaders =[ #"Method"="POST", #"Authorization"="Bearer " & SlackToken ], theCursor = "", GetData =() as table => let url = if theCursor = "" then vUrl else vUrl & "&cursor=" & theCursor, Source = Json.Document(Web.Contents(url , [Headers=vHeaders])), tab = Table.Combine({Table.FromList(Source[users], Splitter.SplitByNothing(), null, null, ExtraValues.Error)}), theCursor = source[response_metadata][next_cursor] in tab, Custom1 = List.Generate( () => [LastCount=2,res=GetData()],each [LastCount]<=3,each [LastCount=Table.RowCount([res])+1,res=GetData()],each [res]), #"Converted to Table" = Table.FromList(Custom1, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandTableColumn(#"Converted to Table", "Column1", {"Column1"}, {"Column1.Column1"}), #"Expanded Column1.Column1" = Table.ExpandRecordColumn(#"Expanded Column1", "Column1.Column1", {"id", "email", "is_admin", "is_owner", "is_primary_owner", "is_restricted", "is_ultra_restricted", "is_bot"}, {"Column1.Column1.id", "Column1.Column1.email", "Column1.Column1.is_admin", "Column1.Column1.is_owner", "Column1.Column1.is_primary_owner", "Column1.Column1.is_restricted", "Column1.Column1.is_ultra_restricted", "Column1.Column1.is_bot"}) in #"Expanded Column1.Column1"
