Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
No solutions provided by Microsoft.. Solved recreating the report.. Thank you all!
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.
No solutions provided by Microsoft.. Solved recreating the report.. Thank you all!
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!
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!
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!
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!