Incorrect filters when exporting data

[Strizzolo]

Hi,

I have a Tabular model deployed in Azure Analysis Services. I have a fact table like that:

Id	Value
A	1
B	2
C	4

I have a security role that filters only row "A" and "B".

The users connected to the live connected Power BI report see the correct data (i.e. row "A" and "B").

When they export the table visual in .xlsx, only "A" is saved.

Do you know why?

The report does not contain any filter.

Thank you all.

[JS-bowman]

Hi 
Was there a solution for this ? I have been using the app to export all tabs without an issue. For some reason now it appears that the year filter is being dropped when exporting so the numbers do not match the selection on the visual. 

[Strizzolo · Accepted solution]

No solutions provided by Microsoft.. Solved recreating the report.. Thank you all!

[v-xulin-mstf]

Hi @Strizzolo,

Is your issue solved?

If the issue has been solved, please adopt the solution to help others.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[v-xulin-mstf]

Hi @Strizzolo

This is very strange.
Does this mean that you are exporting data that does not match what is shown in visual?

Please clear your browser cache and try again, and make sure again that the data in visual is not affected by other filters.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[Strizzolo]

Hi @v-xulin-mstf 

sorry for the late reply.

I tried to follow your suggestion and unfortunately it still doesn't work. As you said, the exported data does not match what is shown in visual.

We have contacted Microsoft. When I get an answer I will update this page.

Thank you!

[v-xulin-mstf]

Hi @Strizzolo,

Is your issue solved?

if the issue has been solved, could you share the solution to help others?

Thanks!

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[Strizzolo]

Hi @v-xulin-mstf ,

unfortunately still no solutions.