Forum Discussion
Share options for a Linked Dataflow
You are correct in that for linked tables, they need access to the source. What you can do in the same dataflow with the linked tables, is create a reference to the linked table (right click on the linked table and select reference). This creates a computed table. You can then add additional transformations in the computed table or leave as is. Save the changes, and make sure you refresh and setup a schedued refresh for this dataflow. Your users should now see the computed tables in the dataflow.
You are correct in that for linked tables, they need access to the source. What you can do in the same dataflow with the linked tables, is create a reference to the linked table (right click on the linked table and select reference). This creates a computed table. You can then add additional transformations in the computed table or leave as is. Save the changes, and make sure you refresh and setup a schedued refresh for this dataflow. Your users should now see the computed tables in the dataflow.
Hi blopez11 Thanks for this.
This seems to have done the trick, just to confirm there is no way the user can amend the dataflow and somehow add fields if they manage to amend this dataflow; we have tried to at our end and users are unable to Take over the Dataflow well they can Takeover but they cannot sign in as their Authentication fails.
But trying to look at different scenarios if there is posibilities of a user extracting fields they shouldn't be allowed to see.
Thanks
If you just give your consumers the viewer role on the workspace where the dataflow exists, they should not be able to modify anything in the workspace. Glad to hear it worked.
blopez11 I haven't given them any role to the workspace where the original Dataflow exisits, and it still works; so good work!
