Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I am trying to export underlying data of a chart I have but it is missing some data. For example, my barchart has data for March 2019, June 2019 to March 2020. When I export the data, March 2019 is not included in the dataset. My source file does have the data.
Any idea what's up?
Thanks!
Daren
Solved! Go to Solution.
Hi there
In the App Workspace, click on reports and then for your report, click on the settings button.
Thanks, but I don't think it's filtering anything. Would it be that it is taking only the latest 12 months? Since it's taking 12 months from the latest month, which is March 2020?
Hi,
I have 2 filters applied to this visual. One of the filters is dollar amount greater than $3000, and the other one is a binary field. It seems that when I remove the filter for the dollar amount, March 2019 data present when I export it. However, even if I have the filter on, March 2019 data is in the visual. I don't know if it makes sense or not but if it appears in the visual, shouldn't it appear in the dataset when I export as well?
Hi
This might be caused by filter in report, you could see below images, it will export data which apply filter
You could refer to Export data from visualizations for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
I understand that, but the thing that I don't understand is that since the filter is applied to the visual, e.g. filtering Dollar more than $3000, which means that anything more than $3000 will be included in the visual. However, March 2019 does not appear in the underlying export file eventhough it is in the visual, which does not make sense since whatever is showing in the visual should appear in the underlying export file.
Daren
Hi Gilbert,
Yes it is showing me what I filtered out.
Hi there
It would appear that the filter is causing the data to change the way it is exported?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.