Your users may benefit from using import mode rather than direct query mode. Under the covers Power BI is running a tabular Analysis Services Cube, so import m

Your users may benefit from using import mode rather than direct query mode. Under the covers Power BI is running a tabular Analysis Services Cube, so import mode will be optimized for reporting regardless of the source database indexing. The PBI dataset can be shared across users, so only 1 connection is required to update it, instead of dozens of users hitting the db directly. Also as another person mentioned, reporting is usually done on an separate database to production applications like an operational data store, data lake, or warehouse.