cancel
Showing results for 
Search instead for 
Did you mean: 

Matrix visual doesn't show data ANYMORE if there is not field in the columns.

We have a report in PBI service containing lots of matrixes. The report uses SSAS live connection as a source

They have fields in the rows, no fields in the colums and ofcourse some values.

 

If I download the report and open it in PBI desktop (Version: 2.51.4885.701 64-bit (October 2017)) the report works fine.

 

They worked fine last thursday. Today I get a complaint of the enduser that the report doesn't show data anymore!

I only get the matrix working if I add a field of the columns. 

 

Has there been an update on the matrix visual? Please fix!

 

Status: Accepted
Comments
Regular Visitor

If you don't want to modify every report in Desktop, another workaround allow you to modify just in the Service. When everything will work, you can just re-upload your pbix file without have to change every report again:

 

In Power BI Service, if you click on the "matrix", change it to "table" and change it again to "matrix", you can see the fields appearing and you can put something in the column.

 

In this way you don't have to modify your pbix files and uses them when the issue will be solved.

Frequent Visitor

That workaround doesn't work for me, and It's not a good solution because I've several reports.

 

In PBI desktop it works, but if I republish the report doesn't work.

 

Ramon.

 

Regular Visitor

@rvgfox

 

Try this:

 

"In Power BI Service, if you click on the "matrix", change it to "table" and change it again to "matrix", you can see the fields appearing and you can put something in the column."

 


Best.

Frequent Visitor

Hi @odoardil

 

I've tested but it doesn't work.

 

Ramon

Frequent Visitor

Same issue here. Please sort Microsoft ASAP.

Moderator

Hi all,

 

Update from PG team: 

 

We have the fix ready, I will update with ETA later today. Hopefully we can roll this out over the next 5 days, but it might not hit Production until next week Monday/Tuesday.

 

Best Regards,
Qiuyun Yu

Frequent Visitor

Today

 

It works for me.

Regular Visitor

It is working for me too.

Frequent Visitor

Back to normal.. Great!

 

Moderator

Hi all,

 

The issue should be fixed now. Please test again to see if the issue is gone. 

 

Best Regards,
Qiuyun Yu