Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
What is the max number of columns i can have in table and matrix report in Power BI ?What is the max number of rows we can have in table or matrix ?
@Dhammanand the liitation is stated here https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-data-points
Does anybody have knowledge on max number of columns and rows to have it in table or matrix visual in power BI ?
@Dhammanand wrote:
What is the max number of columns i can have in table and matrix report in Power BI ?What is the max number of rows we can have in table or matrix ?
The online documentation doesn't mention about any limitation, and I'm not aware of any limitation as well. What is your concern about the limitation? Usually for better data presentation, I don't put too many rows in a table/matrix visual. Power BI also has the TOP N filter to limitation data rows in those visuals.
If there is any such limitation, I suspect it is one of memory, which would mean the maximum number of rows depends on how many columns you have.
Proud to be a Super User!