Forum Discussion
Solved
Get data from SQL database
I will be hiring someone to create several reports using BI in the near future. I know this must be a basic questions but I couldn't find the answer quickly and easily... When someone uses BI to...
Power BI cannot change any data in any source system (SQL , CSV, Excel etc.) so you only need to provide read access.
It could potentially place a lock on tables while it is reading data, which may interfere with other read/write operations going on with the table being read from. So in the unlikely event this becomes a problem, you may want to consider some staging/output tables that are used only by Power BI.
itchyeyeballs
Impactful Individual
Impactful IndividualPBI itself cant change data in your database but you will need to be careful how you provide access.
The simplest thing would be to create a read only user in the database and make sure that user only has access to the relevant tables.