Forum Discussion
rdalton2100
7 years agoRegular Visitor
Recommendations for Dataset Management
We have struggled to find a best practice in regards to reusing standard data entities across our company. I expect that our use cases are commonplace. I am hoping that others have found solutions ...
v-diye-msft
7 years agoCommunity Support
Hi rdalton2100
Do you mean there're 50 writers, working on same SQL server and database, but different operation on the data source?
I think they can model the data in desktop by connecting to the SQL server individually, and then publish the report to same workspace using different filename. then the workspace admin add the gateway, and manage the source info under the data source setting. ( Only need input the SQL server and database name once time), and share the gateway with 50 writers.
Then every time the datasource refreshed, 50 reports will refresh accordingly.