cancel
Showing results for 
Search instead for 
Did you mean: 
0

Exporting Data from Matrix with Live Connection Errors

I tried exporting data from a matrix visual (with filters) that is connected to a live connection but the information exported was not the same as the matrix information and was inaccurate. I was only exporting 5 rows of data so it should not be a number of rows limitation.

 

Anyone knows why?

Status: Delivered
Comments
Moderator

Hi @triciatoh

 

Does the issue happen in Power BI desktop or service? Does the report connect live to SSAS? 

 

Would you please share more information about "information exported was not the same as the matrix information and was inaccurate"? 

 

Best Regards,
Qiuyun Yu 

 

New Member

This issue happens in Power BI desktop. The report is connected live to SSAS.

 

I created a matrix so you are able to drill down the rows/ columns based on the existing hierarchy from the live connection in SSAS. Upon drilling down, I should be able to export via excel the data I see in the matrix but instead of 5 rows of unique rows of data, I get 3 rows of unique rows of data and 2 rows of duplicated non-unique rows of data.

Moderator

Hi @triciatoh

 

Please update Power BI desktop to the latest version 2.69.5467.1751. If the issue still occurs, I would suggest you create a support ticket to let engineers look into the issue on your side. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu 

Moderator
Status changed to: Delivered