Forum Discussion
Card Visual that suggests whether matrix can be exported
Hi Everyone,
I have received this requirement where on top of every matrix visual I have to display a card visual that says whether the matrix can be exported without getting "Exported data exceeded the allowed volume." error. If there are too many rows, Card visual should say, filter to export without error. Users are selecting "Data in current layout" option while exporting from sevice.
How can this be acheived. Please advise.
Hi. You could create a measure checking the amount of rows o the matrix. If the limit is exceed then show a message. Add the measure at the card. You could even make it invisible untill the limit is there like a warning.
Like this: https://blog.ladataweb.com.ar/post/631231479177936896/powerbi-creando-mensajes-de-aviso-o-alerta-en
Here you have the limits: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-desktop
I hope that helps,
1 Reply
- ibarrau
Super User
Hi. You could create a measure checking the amount of rows o the matrix. If the limit is exceed then show a message. Add the measure at the card. You could even make it invisible untill the limit is there like a warning.
Like this: https://blog.ladataweb.com.ar/post/631231479177936896/powerbi-creando-mensajes-de-aviso-o-alerta-en
Here you have the limits: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-desktop
I hope that helps,