Report matrix visual which is not updating

[Yvonne24]

Hi all,

I created a report with on one page a slicer and the other page a matrix which is controlled by the slicer.

With the slicer I can filter on costumer-name.

The matrix contains conditional formatting and a lot of collapsable data (so I have a vertical scrollbar on te right, as it doesn't fit on 1 page)

What I want is a visualisation which can be shared with my customer. The visual needs to shows the matrix but the slicer can not be altered. So customers can only see their own data and not that of other customers. (can also be a dashboard, powerpoint, excel, pdf etc) 

I tried exporting to powerpoint. But embedded as image, does not give the customer the ability to scroll and collaps/expand. And embedded as live data, the customers need a powerbi licence themself to view.

I also tried create subscription. But than all customers get the samen filtered data, and nit just their own.

Can anybody help me out?

Regards,

Yvonne

By the way I have a powerbi Premium per user licence.

[v-xiaoyan-msft]

Hi @Yvonne24 ,

Please correct me if I misunderstood what you meant.
Are you referring to the fact that when you export the data, the data in the matrix is incorrect?
Did you select "Export data with current layout" when you exported the data?
Or did you apply RLS to your report?

Best regards.
Community Support Team_ Caitlyn

[Yvonne24]

Hi,

I use indeed exporting the data. However then I have to export te excel (still dynamic with selected client). However I need to do this every month for every client (hundreds).

When I use export to Powerpoint "insert graph" then the matrix becomes statics. So not able to scroll, or expand/collaps data.

When I use export to Powerpoint "insert live data" then I get an error message in powerpoint that powerpoint is not up-to-date. However I have office 365 with automated updates. So that is strange.

When I use the add-in within Powerpoint I get a dynamic view indeed, however it also includes a link to the whole report (including other clients).

Regards,

Yvonne