What is best practice self service is end users are using our Azure SQL

[powerbihelp87]

For example is Team A pulls in Finance Table and SUpply Chain Table Import

team B needs Finance Table & Tax Table 

what is best practice?

let users use the SQL server importing same table several times or provide PBI Data sets

[KNP]

It depends.

If you have skilled end users who are not creating queries that are negatively affecting the performance of the database, then maybe that's fine in your scenario.

Ideally, you would create reusable assets, like semantic models, that have everything an analyst needs to build the reports/visuals.

Best practice for one company doesn't always work for another. Target reduced impact on the system and reduced hours in building solutions and I'm sure everyone will be happy.

[powerbihelp87]

thanks! Ideally semantic models work great but users like having 'full control' of the data which isnt always wise either

[Anonymous]

Hi @powerbihelp87 ， hello KNP, thank you for your prompt reply!

Is there any progress on this issue?

If you find KNP's answer is helpful to you, please remember to accept it.

It will help others who meet the similar question in this forum.

If you have any further related issues, please feel free to reply!