Johannesburg Fabric / Power BI User Group Meeting
Please join us at 17h00 on the 11th of April 2024 for our next Fabric / Power BI User Group event. The event is hybrid but you are encouraged to join in person, and you can enjoy free pizza and drinks, and you can meet other BI enthusiasts. This is an "out-of-cycle" event because of the various holidays in March and April, and our next event will fall back into the usual cycle and will be on Thursday the 30th of May. The agenda for the April event is as follows: BI News - Siya Zungu Fabric News - Stefan Janse van Rensburg BI Flash: Using pagination to build large data queries quicker - Tiaan Rossouw Main Presentation: DevOps in BI - Michael Victor For more information, and to RSVP, please use this Meetup link.
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"
