I have just recently (past 2 days) begun exploring Dataflows for our company to use, so we can leverage the expertise of the people who really ‘know’ a given database.
One thing I have run into is that I cannot find a way when setting up the Dataflow to define the table connections.
For example, if I’m building a dataflow using customer-related tables, to me it makes sense to say that if I have both the customer table and the customer department table, they connect via the customer number.
Is this possible, and I’ve completely overlooked how to do it, or am I completely out of line to think this should be possible?
I realize that I can define this in the dataset, and then share the dataset with my other BI Report Buddies in the company. But I still think it would make more sense to have groups of tables that the other report builder could just grab and know the connections between the table are logical. Then they could build their own dataset.
NOTE: I am not using Premium Capacity (no choice to do that)