Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I changed the datasource in my BI report, and now the report does not seem to be using my relationship between Suppliers and Orders, (supplier number) *:1 (one direction suppliers -> orders). As my reports are supplier oriented, this means that the data is not being shown in the reports as associated to the different supplier numbers. I have checked that there are order numbers for the corresponding suppliers, and that they are exactly the same (no extra spaces etc). I'm a bit stuck as to why else BI wouldn't be using the relationship to enable me to bring data.
To give you an idea, my table has supplier numbers, then a count of orders, etc.
Hi @Anonymous ,
How about reload your tables?
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Delete and create relation again and check is it still 1-Many or active
Hi,
I already tried that, and yes it still is.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |