Forum Discussion
Analyze in Excel does not export links between tables
All relationships and measures would also work in [analyse in Excel] if you are not getting the correct filtering behaviour then I would check those relationships in the model.
You can also test by creating a report against the same model in the service.
I would validate that these relationships are correct
Hi Mike,
I have a table for the products, a table for the products category, a table for Date, a table for sales, etc.
There are all linked.
When I use [Analyse in excel] and try to make a report for the sales amount of oranges sold in 2020, it does not work. The amount I get is the amout of all sales for all categories and all products.
It seems to have a connexion to the dataset but does not respect the JOIN between tables.
Am I right ?
All relationships and measures would also work in [analyse in Excel] if you are not getting the correct filtering behaviour then I would check those relationships in the model.
You can also test by creating a report against the same model in the service.
I would validate that these relationships are correct