Forum Discussion
Differences between Datasets and Reports
Hi all, I'm having some trouble with my dataset and a report I've built using the dataset. I've published the dataset to a workspace, and then open up PowerBI and connect to my dataset via the Po...
The cardinality is many to manyYou want a 1:* relationship from the calendar table to the fact table, with single direction.
It has to be many to many I believe, as there's a region column in the Targets table, so each region has a target per month. Setting the cardinality to anything other than many-to-many produces an error.
It also works as intended in the model file, but not in the report. Surely if the cardinality was incorrect the model simply wouldn't serve up what I need in either file?
Here's a dummy of what the two tables look like, I've tested these outside the main model (which is vast), and pretty sure the relationship is configured correctly... though perhaps I need to bring in another fact table.