Forum Discussion
bvbull200
Helper III
Helper IIISuggestions for Displaying 100+ Datapoints on Report
I am needing a report that shows roughly 100 datapoints for a single sku #. The data is pulled from a 3.5MM+ row table that is loaded as the dataset. I have no measures and no on-the-fly calculatio...
lbendlin
Super User
Super UserHere's a poorly kept secret: Power BI visuals render in groups of five. So while individual visual may render fast by themselves, they will have to wait for all the other visuals to render first.
One way of mitigating that is to use small multiples. Another way is to use paginated reports. A third way would be to not do this at all, at least not in Power BI. Power BI is not a microservice (ie not primarily designed to show individual details)
bvbull200Do you have a suggested service to use in place of Power BI? Something in the Microsoft ecosystem, preferably. It would juts need to reside in some web-based service for sharing/accessing.
- lbendlin
Nothing as simple as Access, no. You could look at PowerApp, but that might not be fast enough.