Doubt with Power query – database conection

[Syndicate_Admin]

Hello everyone,

I want to build some dashboards and queries for my Company, given that our ERP is not so complete and it lacks of data visualization.

But, as it is the first time I connect PQ with an Access database, I want to make sure that its not going to harm Company data or cause any kind of conflict. The main reason I ask this is because the ERP is connected to the database and employees use it at the same time.

So I just wanted to know if by connecting PQ to Access database I could do any harm to my company data or is it totally safe, or should I know something in advance...??

Thank you very much!

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

Making any changes in Query Editor won't affect your origianl data from database.

If you update the source data in database, you should click the refresh button manually so that the dataset loaded to desktop will be updated correspondingly.

Refer to:

Power BI security white paper - Power BI | Microsoft Docs

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.