Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hey guys,
I'm an intern who is trying to find a .pbviz file of a basic table visual that isn't super outdated. I'm looking for one because my managers and I noticed that the default table visual only goes up to (around?) 500 rows. I desperately need a .pbviz file for a custom table visual so I can set the maximum to 30,000 datapoints. I tried to see if Microsoft has their .pbviz file of the table visual uploaded anywhere, but I can't seem to find it. If anyone could help, please do! I'm desperate for a response and don't have enough time to create my own .pbviz from scratch - I'm just testing to see how my report will function with a lengthier table visual. Thank you to anyone who can help me!
Solved! Go to Solution.
Hi @Anonymous,
MS doesn't open source their table visual. Even if they did, core visuals and custom visuals are very different in how they work; custom visuals have a subset of curated APIs and permissions and run in sandboxed iframes (vs. core visuals which are inline div elements in the report canvas).
I'm not aware of any open source examples that you can readily crib, but it would be fairly easy to integrate one of the many available JS table libraries, or even render a simple table if you're just looking to check things out before you go too far. For the latter, I wrote this intro to the table data view mapping a very long time ago (so it may not be 100% correct for the latest changes, but it may help you with rendering a basic table).
However, you would still need to meet the requirement to handle more than 30K rows. You can use the fetch more data API to do this, and you'd have a couple of options. I might consider one of the following strategies if I were to attempt it:
Regards,
Daniel
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Hi, @Anonymous
As @Greg_Deckler said, "The default table visual can scroll for many thousands of rows." and the documentation says "Virtualization (data windowing) by using Window of 500 rows at a time.".
So even if you have bilions of rows, they will be "incrementaly" loaded as you scroll
However, if you really want to implement your own custom visual, as @dm-p said, you can draw you table using plenty of JS libs and then use the fetchMoreData API to fetch up to 1M rows
By the way, @dm-p already developed an implentation of the fetchMoreData API (thanks for that) with table mapping: dm-p/powerbi-visuals-fetchMoreData-SDKv3: Simple implementation of fetchMoreData in the Power BI Custom Visuals SDK v3 (github.com)
Hi, @Anonymous
As @Greg_Deckler said, "The default table visual can scroll for many thousands of rows." and the documentation says "Virtualization (data windowing) by using Window of 500 rows at a time.".
So even if you have bilions of rows, they will be "incrementaly" loaded as you scroll
However, if you really want to implement your own custom visual, as @dm-p said, you can draw you table using plenty of JS libs and then use the fetchMoreData API to fetch up to 1M rows
By the way, @dm-p already developed an implentation of the fetchMoreData API (thanks for that) with table mapping: dm-p/powerbi-visuals-fetchMoreData-SDKv3: Simple implementation of fetchMoreData in the Power BI Custom Visuals SDK v3 (github.com)
@Anonymous Another option might be Deneb. I've done some cool things with Deneb in terms of tables (like fixing totals for example)
Hi @Anonymous,
MS doesn't open source their table visual. Even if they did, core visuals and custom visuals are very different in how they work; custom visuals have a subset of curated APIs and permissions and run in sandboxed iframes (vs. core visuals which are inline div elements in the report canvas).
I'm not aware of any open source examples that you can readily crib, but it would be fairly easy to integrate one of the many available JS table libraries, or even render a simple table if you're just looking to check things out before you go too far. For the latter, I wrote this intro to the table data view mapping a very long time ago (so it may not be 100% correct for the latest changes, but it may help you with rendering a basic table).
However, you would still need to meet the requirement to handle more than 30K rows. You can use the fetch more data API to do this, and you'd have a couple of options. I might consider one of the following strategies if I were to attempt it:
Regards,
Daniel
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
@Anonymous Not sure I understand this. The default table visual can scroll for many thousands of rows.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.